Hello! Can anyone advise on the IF formula to state if a date has passed a number of days? So if the date in “DATE” column is more than 60 days ago, then :white_check_mark:
or :no_entry: .
I’ve been looking through date and time functions in the Formula Field Reference, plus lots of posts in this community, but haven’t been able to find an answer that works.
I’ve got a formula to display the number of days since, and looked into creating a view filtering for those above 60 days (that didn’t work anyway), but I would prefer it to just display :white_check_mark: (60 days or more) or :no_entry: (less than 60 days).
Thank you for your help.
Solved! Go to Solution.