Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
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

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions

Question

Determine miller indices of plane X z 2/3 90% a/3

Answered: 1 week ago