Forum Discussion
Solved
Check due date
Hi All, i’m trying to work out the best way to check a date in a cell to the date today, i want it to return a value in an adjacent cell of either “Due” if is is within the current month, “Overdu...
As variant
=SWITCH( SIGN(EOMONTH(TODAY(),0) - EOMONTH(date,0)), 0, "Due", 1, "Overdue", "Okay")
Maybe something like
= LET(
monthsElapsed, DATEDIF(dates, TODAY(), "m"),
IFS(monthsElapsed=0, "Okay", monthsElapsed= 1, "Due", monthsElapsed>1, "Overdue")
)