#1   Report Post  
Member
 
Posts: 36
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 621
Default 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   Report Post  
Member
 
Posts: 36
Default

Quote:
Originally Posted by Gord Dibben[_2_] View Post
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..
Thank you very much.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
date reminder putlog Excel Worksheet Functions 1 October 25th 07 11:06 PM
how can i set a date reminder to check on something in a certain. vette Excel Worksheet Functions 1 November 7th 06 05:56 PM
I need to set up a date reminder in Excel to pop-up. Amielys Excel Worksheet Functions 0 August 1st 05 08:58 PM
Date Due Reminder George Excel Worksheet Functions 7 April 10th 05 06:59 AM
Date Reminder George New Users to Excel 1 April 10th 05 03:12 AM


All times are GMT +1. The time now is 07:53 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"