ExcelBanter - Excel formula that tells when a date is passed

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

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

- - Excel formula that tells when a date is passed (https://www.excelbanter.com/excel-discussion-misc-queries/224636-excel-formula-tells-when-date-passed.html)

Excel Problem

Excel formula that tells when a date is passed

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

MyVeryOwnSelf[_2_]

Excel formula that tells when a date is passed

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

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

All times are GMT +1. The time now is 03:44 AM.