Problems

1. What is the serial format for January 25, 2006?

2. What is the serial format for February 14, 1950?

3. To what actual date does a serial format of 4526 correspond?

4. To what actual date does a serial format of 45000 correspond?

5. Determine the day that occurs 74 workdays after today’s date (including holidays).

6. Determine the day that occurs 74 workdays after today’s date (including holidays but excluding the current year’s Christmas, New Year’s Day, and Independence Day).

7. How many workdays (including holidays) are there between July 10, 2005, and August 15, 2006?

8. How many workdays (including holidays but excluding Christmas, New Year’s Day, and Independence Day) are there between July 10, 2005, and August 15, 2006?

   Note 

   The file Datep.xlsx contains several hundred dates. Use this file for the next set of problems.

9. Determine the month, year, day of the month, and day of the week for each date.

10. Express each date in serial format.

11. A project will begin on December 4, 2005. The project consists of three activities: Activities 1, 2, and 3. Activity 2 can start the day after Activity 1 finishes. Activity 3 can start the day after Activity 2 finishes. Set up a worksheet that will accept as inputs the duration (in days) of the three activities and output both the month and year during which each activity is completed.

12. We bought a stock on July 29, 2005, and we are going to sell it on December 30, 2005. The stock exchange will be closed on Labor Day, Christmas, and Thanksgiving. Create a list of dates the stock market will be open during the time we own the stock.

13. The file Machinedates.xlsx contains dates on which several machines were bought and sold. Determine how many months and years each machine was kept.

14. Given any date, find a way to have Excel compute the day of the week of the first day of the date’s month.

15. Given any date, find a way to have Excel compute the last day of the date’s month. Hint: DATE(2005,13,1), surprisingly, returns 1/1/2006.