"simsjr" wrote:

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.

End date minus Start Date = Total days
networkday(Start,End) = Workdays
Difference is weekend days