ExcelBanter - can I set a date alarm in Excel

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - can I set a date alarm in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/123250-can-i-set-date-alarm-excel.html)

apache_sim

can I set a date alarm in Excel

Is it possible to set a date the would give an alarm or warning when that
date is about to become due (say 6 weeks in advance).

CLR

can I set a date alarm in Excel

With your "Due date" in A1, put this in B1..........

=IF(TODAY()=A1-42,"WARNING","")

hth
Vaya con Dios,
Chuck, CABGx3

"apache_sim" wrote:

Is it possible to set a date the would give an alarm or warning when that
date is about to become due (say 6 weeks in advance).

All times are GMT +1. The time now is 11:19 PM.