Time Link

[Lecille]

I have a spreadsheet which I use for tracking delivery dates on orders. I need to receive an alert/notification/reminder when the date has expired with 5 days.

Please could you assist?

 

[Lecille]

I have tested the formula and it works! Only one problem, it doesn't alert on all overdue dates. i.e. I can have a date in April and it puts 'overdue'. When I have for instance 08/08/2010 - it doesn't alert, but on date 09/08/2010 it does!

Any suggestions?

 

[VoG]

That's because of your specification here http://www.mrexcel.com/forum/showpost.php?p=2408859&postcount=6 that it should alert on odd days on or after the 5th day.

 

[Lecille]

Good morning! No I have not used different dates as I initially requested. I am using your formula as suggested - 5 days only.

 

[VoG]

If you just want to be alerted if it is over 5 days then

=IF(TODAY()-D1>=5,"Overdue","")

 

[Lecille]

Thanks, will try it...... and it WORKS!
Thank you very much for your assistance! It is greatly appreciated!!!