Time Link

Lecille

New Member
Joined
Aug 6, 2010
Messages
9
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?
 

Some videos you may like

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

Gerald Higgins

Well-known Member
Joined
Mar 26, 2007
Messages
9,115
Hi, welcome to the board.

What exactly do you mean by "the date has expired with 5 days" ???
 

Lecille

New Member
Joined
Aug 6, 2010
Messages
9
Hi there, hope this makes sense.

I have a date in column D i.e. 15/04/2010 (order date)
I need a notification to alarm when it is now due (5 days later) i.o.w. on the 20th it needs to notify me - only if no date has been entered into column E (estimated shipping date)

Thanks
 

Gerald Higgins

Well-known Member
Joined
Mar 26, 2007
Messages
9,115
OK. Do you also want it to notify you if it is MORE than 5 days later ?

Also, what do you want the notification to look like ?

Easy options are
1) change the cell colour or text colour
2) make a message appear in another cell, saying it's due.

I'll explain how to do these two.
 

Lecille

New Member
Joined
Aug 6, 2010
Messages
9

ADVERTISEMENT

A formula for your second option 2. is exactly what I am looking for.

Thanks, your assistance is greatly appreciated!
 

Lecille

New Member
Joined
Aug 6, 2010
Messages
9
I would like for notification to take place 5 days, 7 days, 9 days, 11 days
 

Gerald Higgins

Well-known Member
Joined
Mar 26, 2007
Messages
9,115

ADVERTISEMENT

Er, ok, so what if it's 6, 8, 10, 12, 13, 14, 15 days and so on ?
 

Lecille

New Member
Joined
Aug 6, 2010
Messages
9
The amount of days can be set on the formula? Right? Can you please help by giving me the formula? Thanks a lot!
 

VoG

Legend
Joined
Jun 19, 2002
Messages
63,650
Try this: formula in E1 copied down

Excel Workbook
DE
103/08/2010Overdue
204/08/2010
305/08/2010Overdue
406/08/2010
507/08/2010Overdue
608/08/2010
709/08/2010Overdue
810/08/2010
911/08/2010
1012/08/2010
1113/08/2010
1214/08/2010
Sheet3
 

Watch MrExcel Video

Forum statistics

Threads
1,108,449
Messages
5,523,060
Members
409,495
Latest member
bkahn

This Week's Hot Topics

Top