Date Reminder

[Moideen]

We are maintaining employees passport details in excel, Is there an
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.

 

[Gord Dibben]

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 CF>Formula is:

Or you could have a VBA message box pop up if you wanted to go that
route.


Gord

 

[Moideen]

;1552520']You can use Conditional Formatting to have th
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 CF>Formula 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

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..-

Thank you very much