How to subtract weekend days?
 

hi,
=networkdays(start,end,holidays) is the formuala
it has 3 parts. assume formula is in A1
start is the cell your start date is in i.e. B1
end is the cell your end date is in i.e. C1
holidays (optional)is a range of cells that you may have
holiday dates in i.e. D1:D10

-----Original Message-----
Hi,

I'd like to know if there's a way to make Excel subtract
weekend days when
calculating actual workdays.

For example, I have cells for the start date and end date
of a sales
forecast. Let's say it's for three weeks (21 days). Now,
what I'd like to do
is subtract the weekend days (there are 6 in this period)
to get the "15".

Now, if I was only doing a forecast for three weeks at a
time, I could just
have Excel subtract the 6 weekend days with a simple
subtraction formula.
However, we want this report to scale to any time period
and subtract any
weekend days that occur in that period.

Make sense? Is there a way to do this? I have Excel 97 if
that means anything.
.