Trying to conditionally highlight a cell if "Purchase Date" is greater than Today(-1825)

I've tried using the conditional format logic, but any time I try and set a date condition, other than a calendar date or "TODAY" then I get "not a valid date" error message.


I'm trying to set an at-a-glance LCR cell highlight if we exceed 5 years from the purchase date. Sorry to be obtuse, but sure could use a nudge in the right direction. Thanks in advance for any assistance.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!