#1   Report Post  
rsteiner1
 
Posts: n/a
Default 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 ?
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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
NETWORKDAYS() not avaialbe after reopening Stan Excel Worksheet Functions 2 June 19th 05 04:53 PM
NETWORKDAYS function problem Arvi Laanemets Excel Worksheet Functions 5 April 19th 05 08:10 AM
Calculating days between current date and a date in future NETWORKDAYS() function Faheem Khan Excel Worksheet Functions 2 February 10th 05 07:18 PM
Networkdays shows as #NAME even though I have the toolpack instal. mark Excel Discussion (Misc queries) 1 December 1st 04 09:13 PM
MS Excel Function - Networkdays Nilesh Inamdar Excel Worksheet Functions 3 November 26th 04 07:10 PM


All times are GMT +1. The time now is 01:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"