ExcelBanter - date notifications from spread sheet

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

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

- - date notifications from spread sheet (https://www.excelbanter.com/excel-worksheet-functions/243123-date-notifications-spread-sheet.html)

Carl

date notifications from spread sheet

want to have an approaching date in excel sheet generate notification

Pete_UK

date notifications from spread sheet

Suppose you have a future date in A1, then you can put this formula in
B1:

=IF(A1-TODAY()<0,"Time's up",IF(A1-TODAY()<8,"One week to go",IF(A1-
TODAY()<31,"Final month","Lots of time yet")))

This should give you some ideas to play with.

Hope this helps.

Pete

On Sep 18, 4:41*pm, Carl wrote:
want to have an approaching date in excel sheet generate notification

All times are GMT +1. The time now is 04:31 AM.