O'Reilly logo

Microsoft® Excel 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

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

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