Date in a cell is before or after a date in another cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to compare the date in two cells. The format is mm/dd/yyyy. How
do I have to change the formula below to make the comparison work?

=IF(C1<8/1/2007,F1,0)
 
=IF(C1<--"2007-08-01",F1,0)

or

=IF(C1<DATE(2007,8,1),F1,0)


assuming you meant August 1st and not January 8th
 

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

Excel 2002: How to make the date format uniform ? 1
When subtracting dates issue 11
Date Format 2
Split date from date time cells dd/mm/yyyy hh:mm. New cell dd/mm/y 2
Excel - convert dates to text but appear as a date format 6
Excel 2007 displayed dates 2
Date and years calculation 2
want formula bar date to be dd/mm/yyyy instead of mm/dd/yyyy.How? 1

Back
Top