Microsoft Excel 2013: Data Analysis and Business Modeling

Chapter 6. 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 can I change it to a normal date?

• Can I use a formula to display today’s date automatically?

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

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

• I have 500 dates entered in an Excel worksheet. How can 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 ...