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!