NETWORKDAYS, WORKDAY and WEEKDAY practice exercises
Count the working days between two dates, find the date a number of working days ahead, and tell which day of the week a date falls on.
- 1Count working days with NETWORKDAYSIn C2, use NETWORKDAYS to count the working days, Monday to Friday, from the start date in A2 to the end date in B2.
- 2Working days around EasterPremiumThe office is closed on the days in E2:E4. In C2, count the working days from A2 to B2 with NETWORKDAYS, and give it E2:E4 as the holidays.
- 3Delivery date with WORKDAYPremiumDelivery takes the number of working days in B2. In C2, use WORKDAY to find the delivery date for the order date in A2.
- 4Day of the week with WEEKDAYPremiumIn B2, use WEEKDAY with 2 as the second argument to number the day of the week of A2, with Monday as 1.
- 5Delivery date over the holidaysPremiumThe office is closed on the days in E2:E5. In C2, find the delivery date B2 working days after the order date in A2. Use WORKDAY and give it E2:E5 as the holidays.