Hi
use NETWORKDAYS for this (note: you have to install the Analysis Toolpak for
this)
"mpetersen" wrote:
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.
|