Question

In cell H7, create a formula that uses the NETWORKDAYS function to calculate the number of...

  1. In cell H7, create a formula that uses the NETWORKDAYS function to calculate the number of working days between the dates in cells H5 and H6.
Engineering   Computer-Science   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

NETWORKDAYS function in Excel is used to count the number of working days between the two dates,it will not add the weekends and we also have the option to specify the holidays as well.

Below you can see the formula ,where holidays is a optional field

=NETWORKDAYS(start_date, end_date, [holidays])

The formula for the given problem can be written as

=NETWORKDAYS(H5,H6)

I have given some date values in cell H5 and H6 for demo only

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
In cell B13, create a formula without a function using absolute references that subtracts the values...
In cell B13, create a formula without a function using absolute references that subtracts the values of cells B5 and B7 from cell B6 and then multiplies the result by cell B8. Copy the formula from cell B13 to the range C13:H13.
add formulas to complete the table of hours used. in cell B17, create a nested formula...
add formulas to complete the table of hours used. in cell B17, create a nested formula with the IF and SUM functions that check if the total number of hours worked in week 1 (cells B9:F9) is equal to 0. if it is, the cell should display the total number of hours worked in week 1. copy the formula from cell B17 to fill the range B18:B20
Create a formula using the PMT function to calculate the monthly loan payment using interest rate...
Create a formula using the PMT function to calculate the monthly loan payment using interest rate and loan period values in cells C4:C8. Enter the formula with a - (negative) sign to return positive value. Do not specify values for the optional arguments fv or type. Loan amount: $1,000,000 Interest Rate APR- 5.0% Monthly Interest Rate- 0.4% Payment periods (years)- 5 Period (months)- 60
Enter a formula in cell B9 using the IFS function to calculate the owner's draw from...
Enter a formula in cell B9 using the IFS function to calculate the owner's draw from the company. If the value in cell B7 is greater than or equal to 500000, the draw amount is 50000. If the value in cell B7 is greater than or equal to 150000, the bonus is 5000. If the value in cell B7 is less than 150000, display the text "no draw".
You can create an in cell bar chart with the text function REPT! (True or False?)...
You can create an in cell bar chart with the text function REPT! (True or False?) Hint: Try the following: Put the numbers 100, 20, 80, 50 in cells A1 to A4. In cell B1 enter the formula: =Rept("o",Int(A1/5)) and copy it down. Try changing the font type to Wingdings. Play around with the numbers and see what happens. You could also try =rept(" ",int(A1/5))&"o". True False
write the flow chart and PsuedoCode 1. Make a peanut butter sandwich. 2. Calculate the value...
write the flow chart and PsuedoCode 1. Make a peanut butter sandwich. 2. Calculate the value of n! Do not use the factorial fn, use the actual recursive definition**. 3. Draw a deck of cards from a standard deck of 52 cards until the queen of hearts is drawn. How many cards did you draw? 4. Fibonacci Numbers. The Fibonacci Numbers are an interesting sequence of positive integers where each value is the sum of the previous two values. We...
In cell B9, create a payment function using the information provided in cells B2:B6. Make sure...
In cell B9, create a payment function using the information provided in cells B2:B6. Make sure that every cell is referenced in the formula. A B Input Area Cost of home $150,000.00 Down Payment $ 10,000.00 APR 4.00% No. Years for Loan                30 Payments Per Year                12 Output Area Monthly Payment ($5,600.00) My answer: =PMT(B4,B5*B6,B2-B3) Which comes out to $5,600.00 a month. Is this right, because i don't think so.
10. Compute the monthly cost of gas. Copy the formula to the appropriate cells for the...
10. Compute the monthly cost of gas. Copy the formula to the appropriate cells for the other vehicles. In cell C21, enter a formula to calculate the number of miles you expect to drive each month. Divide the value of number of miles (cell A5 from the Data sheet) by the average MPG for the vehicle multiplied by the price of a gallon of gas (cell A6 from the Data sheet). Copy the formula to the appropriate cells for the...
In cell B7, enter a formula without using a function to determine the profit generated at...
In cell B7, enter a formula without using a function to determine the profit generated at the Downtown location by subtracting the store’s expenses (cell B6) from the store’s sales (cell B5) for the week of March 1-7, 2018. Copy the formula you created in cell B7 to the range C7:D7.
How do I write a formula in a cell for Excel for this statement: "In cell...
How do I write a formula in a cell for Excel for this statement: "In cell B27, determine the hold time failure rate by using the SUM function to total the values in column I and then dividing that sum by the total number of calls overall in cell B6."
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT