formula for cycle time from date -to-date w/o weekend included

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

I am tracking number of days between two date points with the
=L933-K933 formula. With formula it give the total days.

K933 | L933 | days
10/1/03 | 10/6/03 | 5

With this example, it includes the weekend in the formula.

Is there a way to tell my formula to only include business days?

Steve
 
Steve,

Lookup NETWORKDAYS in help. It's part of the Analysis Toolpak addin, so you
will need to install that.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Use the Analysis Toolpak Add-in's NETWORKDAY() function:

=NETWORKDAYS(K933,L933) ===> 4

NETWORKDAYS counts both the start date and end date as a full day,
so you may need to adjust the formula to


=NETWORKDAYS(K933,L933)-1 ===> 3
 
Back
Top