Thanks so much Ron ....This helps a GREAT Deal!

"Ron Coderre" wrote:

I don't recall which version of Excel first had those functions. I *thought*
Excel 2000 did, though. First, see if you have the Analysis ToolPak (ATP)
add-in installed. If NO, engage the ATP....the functions are in it.

Otherwise, try this:

Workdays:
A1: StartDate
B1: EndDate
C1: =SUMPRODUCT(--(WEEKDAY(ROW(INDEX(A:A,A1):INDEX(A:A,B1)),2)<6))

OR€¦if Holidays will be involved
With a list of holidays in cells J1:J5
C1:
=SUMPRODUCT((WEEKDAY(ROW(INDEX(A:A,A1):INDEX(A:A,B 1)),2)<6)*ISNA(MATCH(ROW(INDEX(A:A,A1):INDEX(A:A,B 1)),$J$1:$J$5,0)))

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

XL2002, WinXP


"Tanisha" wrote:

What function do I use if my version of Excel 2000 does not have the =WORKDAY
or =NETWORKDAYS function?