Conditional dates formulas

[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?

 

[Bob Phillips]

=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)

 

[Guest]

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)




.