Michael_Lockard
New Member
- Joined
- Oct 4, 2008
- Messages
- 2
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
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