Dates Excel 2000

T

Tanisha

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

Ron Coderre

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,B1)),2)<6)*ISNA(MATCH(ROW(INDEX(A:A,A1):INDEX(A:A,B1)),$J$1:$J$5,0)))

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

XL2002, WinXP
 
T

Tanisha

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

Ron Coderre said:
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,B1)),2)<6)*ISNA(MATCH(ROW(INDEX(A:A,A1):INDEX(A:A,B1)),$J$1:$J$5,0)))

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

XL2002, WinXP
Click to expand...
 
Top