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).