Welcome, @anon39323229,
That’s not possible today, but in the recent announcement of basic formula custom field is a mention of additional functionality coming, and another post in that thread asks for the same “today” calc ability, so we’re hopeful…
Thanks,
Larry