Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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.......... |
#2
|
|||
|
|||
-- 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.......... |
#3
|
|||
|
|||
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.......... |
#4
|
|||
|
|||
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.......... |
#5
|
|||
|
|||
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.......... |
#6
|
|||
|
|||
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.......... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculate future date | Excel Worksheet Functions | |||
calculate anniversary of date after specified date | Excel Worksheet Functions | |||
calculate no. of years between a date and today's date | Excel Worksheet Functions | |||
Calculate Due Date | Excel Worksheet Functions | |||
calculate weeks from a start date ( not yr weeks) | Excel Worksheet Functions |