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")
EDATE() is not supported in SharePoint, list of available functions is here Examples of common formulas in lists - Microsoft Support
Equivalent of
=EDATE( TODAY(), 4)could be
=DATE( YEAR(TODAY() ), MONTH( TODAY() )+4, DAY(TODAY() ) )which shall work in SharePoint.
More samples Examples of common formulas in lists - Microsoft Support
Thank you!! Got it to work!
Great to know you sorted this out, thank you for the feedback.