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)

"gcotterl" <(E-Mail Removed)> wrote in message news:c221f441-db8d-4179-ba94-(E-Mail Removed)...
> 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