![]() |
NETWORKDAYS Help
I have a spreadsheet that contains: Start Date End Date Holidays Hourly Rate What I'm trying to do is break out each month's billings (8 hours day) using =NETWORKDAYS. Any ideas on how to pull each month out ? :eek: I can do total days - but am stuck with monthly breakouts. So if a guy starts working on 1/1/2005 and Ends 7/4/2005 - I'd like to be able to pull his Jan, Feb, etc. workdays out and calculate spend. Any help would be appreciated !! Thanks Rob -- rsteiner1 ------------------------------------------------------------------------ rsteiner1's Profile: http://www.excelforum.com/member.php...o&userid=26142 View this thread: http://www.excelforum.com/showthread...hreadid=394714 |
All times are GMT +1. The time now is 09:36 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com