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