Formula help...

[luvs_kaos]

I need some serious help I need to create a date calculator but I need to exclude certain dates only if the end date falls on that date.

For example,
1/2/15 and add 15 days... but here is where I am stuck...
Only if the date falls on a weekend or federal holiday I need to skip to the next business day.

(I need this for various numbers such as 15,18,33,35,50 and 63)

I am drawing a complete blank on this...

Anyone have any thoughts or a formula that can help me out with this?

 

[dreid1011]

Perhaps the WORKDAY() function can assist you:

WORKDAY() Function

 

[luvs_kaos]

Thanks. I tried that but I want the weekends to be included, only if the counted date ends on a holiday or weekend do I want it to skip. So if the counted days falls on a saturday it will calculate the next business day would be for Monday's date.

 

[shg]

With A2 containing a date and B2 the days to add,

=WORKDAY(A2+B2-1, 1, Holidays)