smithlenwood9284 smithlenwood9284
  • 09-03-2022
  • Business
contestada

How to calculate working days in excel excluding weekends and holidays.

Respuesta :

sharfrassas
sharfrassas sharfrassas
  • 09-03-2022

Answer:

To add days excluding weekends, you can do as below: Select a blank cell and type this formula =WORKDAY(A2,B2), and press Enter key to get result. Tip: In the formula, A2 is the start date, B2 is the days you want to add. Now the end date which add 45 business days excluding weekends has been shown.

Answer Link

Otras preguntas

A spherical tank is 4 m tall and therefore has a capacity of about 33500 l (note that 4m is its diameter, and one cubic meter is 1000 l). You have been asked to
In the context of the data administration component of a database management system (DBMS), the acronym CRUD stands for _____. Group of answer choices create, r
Describe the five steps in program planning.
4(n+6)+3n is greater than or equal to 3n-4
When human beings move into an area that seems too cold for them, they can wear clothing, build shelters, or cluster around a fire. These activities can be call
Pls answer w/ clear instructions
pls say fast :( its my online test
Can y'all do it for me, because I have no idea about it...Advance thank you❣️​
Explain how you would calculate the total change in bond energy for the reaction H2 + Cl2 -> 2HCl. How would you know if the reaction was endothermic or exot
y=60x-540 what is the slope? what is the y- intercept?