Compare dates (re-stated)

[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)

 

[Hans Terkelsen]

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