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")
like SharePoint likes/supports EDATE. ?
Excel from o365 windows desktop version?
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!
Excel Windows Desktop version does though.
My fault for not clarifying in the original post!