Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Date Reminder
We are maintaining employees passport details in excel, Is there any function for reminding passport expiry date before 10 days
Example : PP Expiry Date : 25.03.2012, Need to get reminder on 15.03.12 with employee name Pls help me.. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date Reminder
You can use Conditional Formatting to have the cells..........date and
name cell turn color when 10 days before due date. A1 contains the date 25.03.12 =A1-TODAY()<11 entered as a formula in CFFormula is: Or you could have a VBA message box pop up if you wanted to go that route. Gord On Tue, 6 Mar 2012 18:13:32 +0000, Moideen wrote: We are maintaining employees passport details in excel, Is there any function for reminding passport expiry date before 10 days Example : PP Expiry Date : 25.03.2012, Need to get reminder on 15.03.12 with employee name Pls help me.. |
#3
|
|||
|
|||
Quote:
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
date reminder | Excel Worksheet Functions | |||
how can i set a date reminder to check on something in a certain. | Excel Worksheet Functions | |||
I need to set up a date reminder in Excel to pop-up. | Excel Worksheet Functions | |||
Date Due Reminder | Excel Worksheet Functions | |||
Date Reminder | New Users to Excel |