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")
Apologies, but is there a way around the EDATE? It doesn't seem like SharePoint likes/supports EDATE. Could be wrong though, but I keep getting an error and even when I isolate EDATE on a test column, it comes out as an error as well.
P.S. Pretty amazing that you figured out E16 is Renewal Date. Just noticed that.
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.
- Will check this out later, thank you! 🙂
- like SharePoint likes/supports EDATE. ?
Excel from o365 windows desktop version?- Sorry, SharePoint does not support/like EDATE.
Excel Windows Desktop version does though.
My fault for not clarifying in the original post!
