#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 23
Default Reminder

Is there any provision to generate a reminder on my excel sheet for a
particular date?
eg:

Date A value Previous Date Reminder
15/6/2009 90 (A1-90)date format on
previous date?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,520
Default Reminder

If A1 is the date mentioned; reminder will appear otherwise blank

=IF(A1=DATE(2009,6,15),"Reminder","")

If this post helps click Yes
---------------
Jacob Skaria


"Vinod" wrote:

Is there any provision to generate a reminder on my excel sheet for a
particular date?
eg:

Date A value Previous Date Reminder
15/6/2009 90 (A1-90)date format on
previous date?

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,346
Default Reminder

Hi,

If the date is in cell A1

=If(TODAY()-90=A1,"Reminder","")

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Vinod" wrote:

Is there any provision to generate a reminder on my excel sheet for a
particular date?
eg:

Date A value Previous Date Reminder
15/6/2009 90 (A1-90)date format on
previous date?

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
Reminder horseman Excel Discussion (Misc queries) 1 September 24th 07 04:34 PM
pop up box reminder laidebug Excel Discussion (Misc queries) 2 August 10th 07 05:40 PM
Auto pop up reminder P2000 Excel Discussion (Misc queries) 1 May 24th 07 03:32 AM
Pop-Up Reminder Tony Excel Discussion (Misc queries) 3 March 4th 05 10:49 AM


All times are GMT +1. The time now is 09:44 PM.

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"