Answered step by step
Verified Expert Solution
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
\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
Get Instant Access to Expert-Tailored 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