Function: days of week in column, Excel 2000 & 2003
 

Hello,

Is there a function that will put days of the week begining in coloumn
e14 for one year excluding holidays based on dates this format 1/1/2007
- 12/31/2007 in Coloumn B2:B13 and excluding weekends?


Thank you for your help in advance,
jfcby

Function: days of week in column, Excel 2000 & 2003
 

Hello Tom,

Thank you the function works great!

jfcby


Tom Ogilvy wrote:
Assume your holiday dates are listed in B2:B13

in E14 put in

01/02/2007

in E15 put in
=workday(E14,1,$B$2:$B$13)

format both E14 and E15 as mm/dd/yyyy (or whatever format you want).

then drag fill down the column.

The workday function is contained in the analysis toolpak, so make sure you
have that installed.

--
Regards,
Tom Ogilvy



"jfcby" wrote:

Hello,

Is there a function that will put days of the week begining in coloumn
e14 for one year excluding holidays based on dates this format 1/1/2007
- 12/31/2007 in Coloumn B2:B13 and excluding weekends?


Thank you for your help in advance,
jfcby