Microsoft® Excel Data Analysis and Business Modeling

Chapter 7. Dates and Date Functions

• When I enter dates into Excel, I often see a number such as 37625 rather than a date such as 1/4/2003. What does this number mean, and how do I change 37625 to a normal date?

• Can I enter a formula that automatically displays today’s date?

• How do I determine a date that is 50 workdays after another date? What if I want to exclude holidays?

• How do I determine the number of workdays between two dates?

• I have 500 different dates entered in Excel. What formulas can I use to extract the month, year, day of the month, and day of the week from each date?

To illustrate the most commonly used month-day-year formats in Excel, suppose today is January 4, 2004. We could enter this date as any of the following:

• 1/4/2004

• 4-Jan-2004 ...