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

Get Microsoft® Excel Data Analysis and Business Modeling now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.