Calculating Production/Man Days in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to calculate production days in Excel instead of calendar days.
Is there a way to do this? That is to say if I start a project on October 1,
2004 and finish it December 13, 2004 I would like to know how many days that
this project was actually worked.

Production days are usually just the days of the week, less any holidays
that are able to be worked.

Thanks for any assistance you can offer.
 
Hi
use NETWORKDAYS for this (note: you have to install the Analysis Toolpak for
this)
 
Use the NETWORKDAYS worksheet function. See XL help.

HTH
Jason
Atlanta, GA
 
If "just the days of the week" excludes weekends...

=NETWORKDAYS(StartDate,EndDate,Holidays)

....where Holidays refers to one or more dates to exclude from the
calculation.

Hope this helps!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate Project dates 2
Calculate Net Work Days for 4 day weeks 4
EXCEL 2003 7 Day Week plus Holidays 1
How to calculate with workingdays instead of calendar days 4
Return Working Day 1 and so on 1
Brainteaser about Days Between Dates 5
Calculating Working Hours, Days and Overtimes. 1
Trying to Calculate a Projected Date 8

Back
Top