ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   NETWORKDAYS Help (https://www.excelbanter.com/excel-worksheet-functions/39785-networkdays-help.html)

rsteiner1

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