O'Reilly logo

Microsoft® Excel® 2010: Data Analysis and Business Modeling by Wayne L. Winston

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required