Microsoft® Office Excel® 2007: Data Analysis and Business Modeling, Second Edition

Chapter 6. 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 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 can I use to extract from each date the month, year, day of the month, and day of the week?

• My business has purchased and sold machines. For some, I have the date the machine was purchased and the date the machine was sold. Can I easily determine ...