Formula to Remove Weekend Days

[Guest]

I have a spreadsheet that I am trying to subtract the days between dates and
remove the weekend days from the calculation.

example: G2 - F2 = ???
5/23/2006 - 5/17/2006 = 4

TFTH,

 

[Guest]

Try this:

For
F2: StartDate
G2: EndDate

This formula requires the Analysis ToolPak add-in (ATP):
H2: =NETWORKDAYS(F2,G2)

This formula does not use the ATP:
H2: =SUMPRODUCT(--(WEEKDAY(ROW(INDEX(A:A,F2):INDEX(A:A,G2)),2)<6))

Note: the NETWORKDAYS function accepts a third argument, a list of holidays
which would not be counted as workdays.

btw...unless you don't want to include the start date, there are 5 workdays
between 5/17/2006 and 5/23/2006...In that case, just subtract 1 from the
formula results.



Does that help?
***********
Regards,
Ron

XL2002, WinXP