Hi Kevin,

I know I must seem really clueless but I just can't seem to make this work.
If I have the worksheet set up with the date being entered in row G1
(hopefully don't need to specify row# because I would like to keep it as a
rolling worksheet) and to utilize the "IF" formula could you show me the
formula. I just can't seem to figure out what I'm missing. How do I set the
formula for the entire column or is this not possible? I do have a row
headings which I do not want to change. I have created another spreadsheet
for my "Holidays" and would like to have this expand as I need to add other
holidays. Is there a way to set up the formula for this? I am just not able
to figure this out without getting more specific to my own scenario. I hope
you don't mind. Thanks so much for all of your help so far...I truly
appreciate it!

"Kevin B" wrote:

Go to a blank worksheet and in a column of your choosing enter in the
holidays, 1 per row. The dates below are the holidays of the company Im
working for.
9/4/2006
10/09/2006
11/23/2006
11/24/2006
12/25/2006
12/26/2006

You can extend the number of holidays out as far as you wish and when all
holidays have been entered, click and drag from the first holiday date to the
last holiday date to select them all.
Then click INSERT on the menu, select NAME and then DEFINE and enter the
name Holidays and click OK.
I did not read your prior post close enough and the NETWORKDAYS is for
calculating the number of work days between 2 dates, what you want is the
WORKDAY function.
For example, if A1 has a date and I want to calculate 4 working days from
that date the and display the result in column B, the formula would be:
WORKDAY(A1,4, Holidays)

Or you could do the following:
Col A Col B Col C
9/5/2006 6 WORKDAY(A1,B1, Holidays)

You could also use and IF function so that if there wasnt a date in column
A the cell would be blank, that way when the formula is copied down the
column you wont have any results displayed for rows that dont have a date:

=IF(ISBLANK(A1),"",WORKDAY(A1,B1,Holidays))
Hope this hasnt made things worse, but if it has Ill check back later to
see what the next post has to say.

--
Kevin Backmann


"DRondeau" wrote:

Thank you for responding so quickly! :) I am not very proficient with Excel
so excuse me if I seem ignorant...when I go into Help and pull up the
information it seems as though I need to have a definite start date and end
date. Is there a way around this to keep a continuous worksheet? If I have
to put dates how far out do the dates go? Say a year or longer? And to
enter the "holidays" do I just create a new column and list one date on each
row?

"Kevin B" wrote:

In help lookup the NETWORKDAYS function.

NETWORKDAY(Date1, Date2, [Optional Holidays])

You can create a named range of all your company holidays and then use the
range name as the argument value for holidays.

If you get a #NAME error you need to go to TOOLS/ADD INS and check off the
ANALYSIS TOOLPACK
--
Kevin Backmann


"DRondeau" wrote:

I am trying to find a formula or function that will enable me to add 4 work
days (Mon-Fri) to a date entered in another column. Dates will change. Also
need to figure out how to format the range for Holidays in order for those to
not be counted as well. I am not quite sure how to format the WORKDAY
function if this is the appropriate choice. Any help would be most
appreciated. I've been working on this for the past week and have had no
luck. Thanks!