IF function using dates as cell references

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

Guest

I need a formula that will compare the dates in two cells and IF one date is
before the other, THEN . . . . Can Excel read a date of 12/31/05 and compare
it to 1/15/06, 9/31/05, etc to give me a result?
 
Yes, providing that the dates have been entered as dates, not as text.

=IF(A1<A2,"Before","After") will work, but of course Excel won't understand
9/31/05 as a date.
 
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

Problem formatting dates from CSV file 2
due dates 7
Sum value between two dates and copy to new cell 6
Date formula 4
help with datedif function please 4
Help with IF formula 3
Calculate elapsed time excluding specific timeframe 10
Termination within number of days 5

Back
Top