Mar 01 2021 12:35 PM
The expiry warning is todays date against the date in column E.
I need a message to populate in column F with one of the three options.
"Past due"
"Due in less than 10 days"
"More than 10 days"
Mar 01 2021 12:51 PM
SolutionIn F2:
=IF(E2="","",IF(E2<TODAY(),"Past due",IF(E2<TODAY()+10,"Due in less than 10 days","Due in 10 days or more")))
Fill down.
Mar 01 2021 01:01 PM
Mar 01 2021 01:01 PM
Mar 01 2021 12:51 PM
SolutionIn F2:
=IF(E2="","",IF(E2<TODAY(),"Past due",IF(E2<TODAY()+10,"Due in less than 10 days","Due in 10 days or more")))
Fill down.