I think you want =Workday(), too.

I'd create a new sheet--maybe even hide that sheet when I was done. Put all the
holidays in column A. Just keep adding to the bottom of the list--don't leave
any gaps.

Then use a dynamic range name that points at that ever growing list of holidays.

See Debra Dalgeish's site for some nice tips:
http://contextures.com/xlNames01.html#Dynamic

Try ignoring the holidays with a formula like:
=WORKDAY(A1,4)

Then you can your named range of holidays after you type it in.

Remember that =workday() requires the analysis toolpak addin to be checked
(tools|addins).


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!

--

Dave Peterson