Comparing dates

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

 

[MerseyBeat]

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)

Let me direct you to a specific page in Chip Pearson's website

http://www.cpearson.com/Excel/datetime.htm#AddingDates