ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Workday calculation (https://www.excelbanter.com/excel-discussion-misc-queries/230255-workday-calculation.html)

heater

Workday calculation
 
I want to know how many workdays have pasted. In cell E6 is the first
workday and E7 is the ending Workday. What is the formula to know how many
Workdays have pasted?

edvwvw via OfficeKB.com

Workday calculation
 
=NETWORKDAYS( Startdate, Enddate, holidays)

I believe that depending on the version number of excel - you may need the
analysis toolpack installed

edvwvw

heater wrote:
I want to know how many workdays have pasted. In cell E6 is the first
workday and E7 is the ending Workday. What is the formula to know how many
Workdays have pasted?


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200905/1



All times are GMT +1. The time now is 09:41 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com