Net Work Weeks?

[Michael_Lockard]

Good day to all. This is my first post, so be gentle

I have searched all over the forums without a good answer. FYI: I am using Excel 2007

I am trying to calculate the net work weeks in a month. I can calculate the number of networkdays thru the NETWORKDAYS formula. However, I need to also calculate the net work weeks to a second decimal point.

For example, January 2008 has 22 net work days (01/01/2008 as a holiday). I need to calculate the number of work dates that represents.

This formula

=ROUND((A2-A1)/7,2)

Shows that there are 4.29 work weeks, but I need to change this formula to factor out the holidays like NETWORKDAYS does.

I am stumped, so your help would be greatly appreciated

Michael Lockard

 

[Scott R]

How about NETWORKDAYS(begindate,enddate,holidays)/5.
That would get 4.4 for Jan 08.

 

[Michael_Lockard]

Thanks! I think that should work great!!!!!!!!!