Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Work Week, Excel 2000 & 2003 | Excel Worksheet Functions | |||
Re Change 5 week days to 7 days in this formula | Excel Worksheet Functions | |||
Excel 2000 versus 2003 and the TEXT Function | Excel Worksheet Functions | |||
Does Excel 2000 have the "List" data function like in Excel 2003 | Excel Discussion (Misc queries) | |||
changes in the date function from 2000 to 2003? | Excel Programming |