Forum Discussion

DeanCalandine's avatar
DeanCalandine
Copper Contributor
Jan 02, 2024
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...
  • SergeiBaklan's avatar
    Jan 03, 2024

    DeanCalandine 

    As variant

    =SWITCH( SIGN(EOMONTH(TODAY(),0) - EOMONTH(date,0)), 0, "Due", 1, "Overdue", "Okay")

Resources