Forum Discussion
DeanCalandine
Jan 02, 2024Copper Contributor
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...
- Jan 03, 2024
As variant
=SWITCH( SIGN(EOMONTH(TODAY(),0) - EOMONTH(date,0)), 0, "Due", 1, "Overdue", "Okay")
SergeiBaklan
Jan 03, 2024Diamond Contributor
As variant
=SWITCH( SIGN(EOMONTH(TODAY(),0) - EOMONTH(date,0)), 0, "Due", 1, "Overdue", "Okay")DeanCalandine
Jan 04, 2024Copper Contributor