ExcelBanter - Date Reminder

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Date Reminder (https://www.excelbanter.com/excel-worksheet-functions/433386-date-reminder.html)

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

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

Quote:

Originally Posted by Gord Dibben[_2_] (Post 1552520)

Thank you very much.