Thread: Excel formula that tells when a date is passed
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
MyVeryOwnSelf[_2_] MyVeryOwnSelf[_2_] is offline
external usenet poster
  
Posts: 143
Default 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","")
Reply With QuoteReply With Quote