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: