Compare dates (re-stated)

G

gcotterl

How can I determine if the date in B1 is after the date in A1?

This is how each cell is formatted:

A1: 06/23/2000 (format: number: custom: mm/dd/ccyy)
B1: 10-01-2003 (format: number: general)
 
H

Hans Terkelsen

gcotterl said:
How can I determine if the date in B1 is after the date in A1?

This is how each cell is formatted:

A1: 06/23/2000 (format: number: custom: mm/dd/ccyy)
B1: 10-01-2003 (format: number: general)

Hi G.

Please understand that formats are just window dressing.
Excel is concerned only with the underlying values.
B1 is after A1 if =B1>A1 is TRUE

For example suppose A1, B1, C1 all contain =TODAY()
Then the cells will be equal even if they show 2010, 2553, 1431

Those are the western, buddhist, islamic years
formats e and bbbb and b2e respectively

Hans T
 

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

Compare dates 0
Compare dates 6
Comparing dates 1
Subtracting time...again 2
separating date and time 5
Date Formats 4
Convert dates 7
Delete Text in Multiple Cells 3

Top