Calculate Due Date?
 

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..........

--
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..........

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..........

See my response to your first post. No need to multi-post.

--
HTH,
Bernie
MS Excel MVP


"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..........

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..........

Ah, me might say that bus does he mean it. I struggle to think of a reason
to have that algorithm, so I make a suggestion based upon a more likely
(IMO) premise. He can take notice or ignore, it's his choice.

Bob

"Bernie Deitrick" <deitbe @ consumer dot org wrote in message
...
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..........