Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dates Excel 2000
What function do I use if my version of Excel 2000 does not have the =WORKDAY
or =NETWORKDAYS function? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dates Excel 2000
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dates Excel 2000
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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dates Excel 2000
At least since Excel 97 that I remember.
Gord Dibben MS Excel MVP On Wed, 26 Jul 2006 09:53:02 -0700, 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, 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 "Tanisha" wrote: What function do I use if my version of Excel 2000 does not have the =WORKDAY or =NETWORKDAYS function? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate number of weeks between dates in Excel 2000 | Excel Discussion (Misc queries) | |||
add/subtract dates problem in Excel..... | Excel Discussion (Misc queries) | |||
How do I create a List in Excel 2000 | Excel Worksheet Functions | |||
other systems detecting excel 4.0 if excel 2000 is installed | Setting up and Configuration of Excel | |||
Statistical Excel Function Question within Excel 2000... | Excel Worksheet Functions |