Question

Problem 12 (modified) - Create your own worksheet. List holidays, calculate workdays between dates, and count dates involved in the project. Use workday, networkdays, datedif, and count functions.

B C D E F G H I J K no Workday Calculator Input Output ON 00 Total Number of Days Start Date 7/26/2019 End Date 12/30/2019 9 Project Length 10 11 Project Approved Project Due 12 13 14 Total Number of Workdays (excludes weekends) 15 16 Date of Holiday 77 Holiday Labor Day Thanksgiving Christmas 18 Total Number of Workdays with Holidays Off (excludes weekends and holidays) Days Billed 19 20 21 22 23 24 LABEL THIS

Answer 1

Input Start Date 7/26/2019 project approved Workday Calculator output End Date Total Number of Days 12/30/2019 Project Due [158 days) Project Length Holiday Labour Day Thankingiving christmas Oale of Holiday .9/02/2019 11/28/2019 1a) 18/2019 Total Number of workdays (excludes weekends) | 112 days Total number of workdays with holidays off (excludes weekends and holidays (158-46-3 2109 days) Days Billed