When setting conditional formatting, it only allows me to set a specific calendar date when choosing "Before" or "After" conditions. Typing "today" returns the error " Value must be of type date".

Is there a workaround? Thanks for any help!