Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Day of the week. 10/15/24 Name of the day. Use the project information on ProjectWorkDays worksheet to complete the tasks. Identify the day of the
Day of the week. 10/15/24 Name of the day. Use the project information on ProjectWorkDays worksheet to complete the tasks. Identify the day of the week for the date in cell E2. a. Place your calculation in cell (C2). b. Use the WEEKDAY function c. Reference cell in your calculation. (3.2) Display the name of the day for the date in cell (E2). a. Place your calculation in cell (C4). b. Use the CHOOSE function. c. Refer the day number calculated in cell (C). d. Use "Sun","Mon", "Tues","Wed", "Thurs", "Fri", and "Sat" as the names of the days. (3.3) Calculate the number of years it took to complete the project in row 7 of the project table. a. Place your calculation in cell b. Use the DATEDIF function. c. Reuse your formula to complete the column. 3.4 Calculate the number of months it took to complete the project in row 7. a. Place your calculation in cell b. Use the DATEDIF function. c. Reuse your formula to complete the column. (3.5) Calculate the number of days it took to complete the project in row 7 of the table. a. Place your calculation in cell b. Use the DATEDIF function. c. Reuse your formula to complete the column. (3.6) Calculate the number of workdays (taking into account weekends) it took to complete the project in row 7. a. Place your calculation in cell b. Use the NETWORKDAYS function. c. Reuse your formula to complete the column. (3.7) Calculate the number of workdays (taking into account weekends that are made of only Sunday) it took to complete the project in row 7. a. Place your calculation in cell b. Use the NETWORKDAYS.INTL function. c. Reuse your formula to complete the column. (3) (3.8) Calculate the number of workdays (taking into account weekends that are made of 3 days - Friday through sunday) it took to complete the project in row 7. a. Place your calculation in cell b. Use the NETWORKDAYS.INTL function. c. Reuse your formula to complete the column. What is the serial number for the date in cell E2
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started