Microsoft® Excel® 2010: Data Analysis and Business Modeling

Chapter 7. Dates and Date Functions

Questions answered in this chapter:

• When I enter dates in 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 it to a normal date?

• Can I use a formula to automatically display 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 an Excel worksheet. How do I write formulas to extract from each date the month, year, day of the month, and day of the week?

• I am given the year, month, and day of the month for a date. Is there an easy way to recover the actual date?

• My business has purchased ...