Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Workday function in XL2000
My company is still running Excel 2000. Is there a work-around to
getting workday? For example, if I reference a cell with the date Jan 23 in it, i'd like the formula to tell me how many workdays were in Jan up to and including that date. Thanks for your help!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Workday function in XL2000
Here's a workaround (from http://www.cpearson.com/excel/DateTimeWS.htm):
Creating A Series Of Workdays If you want to create a series of dates in a column, consisting of only weekdays (Monday through Fridays), enter your starting date in a cell (A4, in the example), and then enter the following formula in the cell below that cell. =IF(WEEKDAY(A4)=7,A4+2,IF(WEEKDAY(A4)=6,A4+3,A4+1) ) Then use Fill Down to fill out your entire series of dates. You would then have to remove any holidays that appear (see http://tinyurl.com/yrqldt) and use the COUNTA function to sum them. ps- are you sure WORKDAY doesn't work in XL 2000? HTH, JP On Mar 11, 8:04*pm, Steve wrote: My company is still running Excel 2000. *Is there a work-around to getting workday? *For example, if I reference a cell with the date Jan 23 in it, i'd like the formula to tell me how many workdays were in Jan up to and including that date. *Thanks for your help!! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Workday function in XL2000
Sounds as if you don't have theAnalysis Toolpak installed.
If you don't need holidays, you can use =SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&A1-DAY(A1)+1)),2)<6)) -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Steve" wrote in message ... My company is still running Excel 2000. Is there a work-around to getting workday? For example, if I reference a cell with the date Jan 23 in it, i'd like the formula to tell me how many workdays were in Jan up to and including that date. Thanks for your help!! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Workday function in XL2000
If you look in Excel help for the WORKDAY function, I think it will remind
you that you need to switch on the Analysis ToolPak. -- David Biddulph "Steve" wrote in message ... My company is still running Excel 2000. Is there a work-around to getting workday? For example, if I reference a cell with the date Jan 23 in it, i'd like the formula to tell me how many workdays were in Jan up to and including that date. Thanks for your help!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using WORKDAY function | Excel Discussion (Misc queries) | |||
WORKDAY function | Excel Worksheet Functions | |||
Using WORKDAY function | Excel Worksheet Functions | |||
Workday function | Excel Worksheet Functions | |||
How do I get the WORKDAY function? | Excel Discussion (Misc queries) |