you have in B10 - February - not the 1st of Jan and then ends on 7/2
so friday to thursday
you can use
=NETWORKDAYS(B10, F10, Q10:Q19 )
will give you the number of workdays - if a standard 8 hour day * 5
Q10:Q19 are the holidays
change B10 to
1/1/13 and it calculates as 4 days
* 8
=32
Bookmarks