Excel formula that tells when a date is passed

  • Thread starter Thread starter Excel Problem
  • Start date Start date
When a date is entered Excel warn me the date is passed

One way:
=IF(A1<TODAY(),"Warning","")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

calculate number of months based on one date 1
Comparing Dates with todays date 3
how to calculate hrs flown in last one year 0
Counting Days 5
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Copy a calculated field 3
Excel How to get the number of days an item was opened from the today's date. 14
Conditional Formatting 5

Back
Top