Workday function in XL2000

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

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!!
 
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
 
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)
 
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.
 
Back
Top