"gcotterl" wrote in message
...
How can I convert a date with custom number format mm/dd/yyyy
(example: 06/23/2000) to a serial number?

How can I convert a date with a general format (example: 10-01-2003)
to a serial number?

Let me direct you to a specific page in Chip Pearson's website
http://www.cpearson.com/Excel/datetime.htm#AddingDates