Forum Discussion
Solved
Formatting with date ranges
Hi, I'm trying to figure out a formula at work and I might go bald trying to figure this out. The characteristics is that from the Approval Date it is a - 12 month duration (default, reflected ...
How about
=IFS(E16="", "",E16<TODAY(), "No", E16<EDATE(TODAY(), 4), "At Risk", TRUE, "Yes")
How about
=IFS(E16="", "",E16<TODAY(), "No", E16<EDATE(TODAY(), 4), "At Risk", TRUE, "Yes")
I love you and appreciate you!! Dang I've been working on this for a few days going over random formulas.
THANK YOU!!!!!!
THANK YOU!!!!!!