"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

Hello,

I suggest to have a look he
http://www.sulprobil.com/html/date_formulas.html

It reads:
Count of working days (Mondays through Fridays without any holidays):
A1 Start date
A2 End date
Formula:
=(A2-WEEKDAY(A2,2)+WEEKDAY(A1,2)-A1)/7*5-MIN(5,WEEKDAY(A1,2))+MIN(5,
WEEKDAY(A2,2))
This formula is different from Excel's built-in function (analysis
add-in). It counts from A1 24:00 until A2 24:00.

HTH,
Bernd