When a date is entered Excel warn me the date is passed
M MyVeryOwnSelf Mar 17, 2009 #2 When a date is entered Excel warn me the date is passed One way: =IF(A1<TODAY(),"Warning","")