Comparing dates
 

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)

Comparing dates
 

"gcotterl" wrote in message
...
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