Dates Excel 2000

[Guest]

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

 

[Guest]

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

 

[Guest]

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

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

 

[Gord Dibben]

At least since Excel 97 that I remember.


Gord Dibben MS Excel MVP