Conditional dates formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have been using this formula to determine if a task is
overdue.
=IF(D7-TODAY()*3,"Overdue","")

I would like to add a condition to that, if the task is
due in 3 days, write "Due in 3 days", instead
of "Overdue".
How do I do this?
 
=IF(D7=TODAY()+3,"Due in 3 days",IF(D7<TODAY(),"Overdue",""))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Thanks! It worked.
-----Original Message-----
=IF(D7=TODAY()+3,"Due in 3 days",IF(D7<TODAY (),"Overdue",""))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)




.
Click to expand...
 
Back
Top