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 ?
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