Bob,

The OP only wants to change the date if the end date falls on a weekend, not if the 10 date period
covers a weekend (which it always will).

HTH,
Bernie
MS Excel MVP


"Bob Phillips" wrote in message
...
Don't you just want to use NETWORKDAYS, it handles weekends and holidays.

--
HTH

Bob Phillips

"Randy" wrote in message
oups.com...
I need a formula that will calculate a due date 10 days from the start
date (a1)but if the date falls on a weekend or holiday I need the date
to be the next working day.

I will have a list of holidays in J2:J50.

Thanks for any help..........