Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

What formula would I use to complete this? In cells C2:C12, use a function to calculate the number of work days between thestart dates in

What formula would I use to complete this?

In cells C2:C12, use a function to calculate the number of work days between thestart dates in cells A2:A12 and the end dates in cells B2:B12 not considering the holiday dates in cells G2:G12. Your formula should leave the number of work days blank in column C if the end date is blank in column B. Hint: Use an IF statement. Check Figure: Cell C4 = 169

image text in transcribed

\begin{tabular}{|l|r|} \multicolumn{1}{c|}{ F } & \multicolumn{1}{c|}{ G } \\ \cline { 2 - 2 } & \multicolumn{1}{c|}{ Date } \\ \hline New Year's Day & 1/1/18 \\ \hline Martin Luther King Jr. Day & 1/15/18 \\ \hline Presidents' Day & 2/19/18 \\ \hline Easter & 4/1/18 \\ \hline Memorial Day & 5/28/18 \\ \hline Independence Day & 7/4/18 \\ \hline Labor Day & 9/3/18 \\ \hline Columbus Day & 10/8/18 \\ \hline Veterans Day & 11/11/18 \\ \hline Thanksgiving Day & 11/22/18 \\ \hline Christmas Day & 12/25/18 \\ \hline \end{tabular} \begin{tabular}{|l|r|} \multicolumn{1}{c|}{ F } & \multicolumn{1}{c|}{ G } \\ \cline { 2 - 2 } & \multicolumn{1}{c|}{ Date } \\ \hline New Year's Day & 1/1/18 \\ \hline Martin Luther King Jr. Day & 1/15/18 \\ \hline Presidents' Day & 2/19/18 \\ \hline Easter & 4/1/18 \\ \hline Memorial Day & 5/28/18 \\ \hline Independence Day & 7/4/18 \\ \hline Labor Day & 9/3/18 \\ \hline Columbus Day & 10/8/18 \\ \hline Veterans Day & 11/11/18 \\ \hline Thanksgiving Day & 11/22/18 \\ \hline Christmas Day & 12/25/18 \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Recommended Textbook for

The Investing Revolutionaries How The Worlds Greatest Investors Take On Wall Street And Win In Any Market

Authors: James N. Whiddon , Nikki Knotts

1st Edition

0071623949,0071700560

More Books

Students also viewed these Finance questions

Question

1. What is meant by franking a letter?

Answered: 1 week ago

Question

How is slaked lime powder prepared ?

Answered: 1 week ago

Question

Why does electric current flow through acid?

Answered: 1 week ago

Question

What is Taxonomy ?

Answered: 1 week ago

Question

1. In taxonomy which are the factors to be studied ?

Answered: 1 week ago