Excel formula that tells when a date is passed

M

MyVeryOwnSelf

When a date is entered Excel warn me the date is passed

One way:
=IF(A1<TODAY(),"Warning","")
 
Top