Date Problems

[slifer666]

Ok Need Help

Ive wrote this

=IF(TODAY>D1110+9, TIMED OUT, NOT RETURNED YET)

What I want is for excel to check if the current date is 9 days later then the Date in Cell D1110, and to return one of the 2 values above

also, in the next cell i want it (if the result is Timed Out) to say "Status 'A'" and if it says "Not Returned Yet" I want it to remain blank

Please help

 

[Domski]

Hi,

Try:

=IF(TODAY()>D1110+9,"TIMED OUT","NOT RETURNED YET")

Then something like:

=IF(A1="TIMED OUT","Status A","")

Hope it helps,

Dom

 

[slifer666]

Cheers,

Had just figured it out just before i read ur reply!

thanks anyway