ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Reminder (https://www.excelbanter.com/excel-worksheet-functions/233902-reminder.html)

vinod

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?

Jacob Skaria

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?


Shane Devenshire[_2_]

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?



All times are GMT +1. The time now is 02:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com