Date function help

I

itty

I have order received date. I will start the order on the next comin
THURDAY always. My delivery date is 9 days from the start.

eg. Received date = 5/7/2004. Start Date is = 8/7/2004. Delivery dat
will be 17/7/2004.
Can somebody help with a formula to calculate delivery date. By the wa
we are into furniture manufacturing.

Thanks in advance,
Itt
 
M

Max

... My delivery date is 9 days from the start.
.. a formula to calculate delivery date.
Click to expand...

If col B contains the start dates, from row2 down

just put in say, C2: =B2+9

(think Excel will format the result in C2
as a "date" in exactly the same format as what's in B2)

Copy C2 down

Col C will return the delivery dates
 
R

Raj

Hi itty,

Try this formula. This formula would calculate the date of next thursday.

=IF(WEEKDAY(Date)<5,A2+5-WEEKDAY(Date),A2+12-WEEKDAY(Date))

Then you can add 9 to it to find the delivery date.

Regards
 
M

Max

It's a good one, Raj !
(Guess I took care of the easy bit only <g>)

Maybe to ease-in itty's implementation (just in case) ...

If your "order received dates" are in col A, A2 down

Put Raj's suggestion in B2:

=IF(WEEKDAY(A2)<5,A2+5-WEEKDAY(A2),A2+12-WEEKDAY(A2))

Put in C2: =B2+9

Select B2:C2 and copy down

Col B will return the start-dates and col C, the delivery dates
 
R

Ron Rosenfeld

I have order received date. I will start the order on the next coming
THURDAY always. My delivery date is 9 days from the start.

eg. Received date = 5/7/2004. Start Date is = 8/7/2004. Delivery date
will be 17/7/2004.
Can somebody help with a formula to calculate delivery date. By the way
we are into furniture manufacturing.

Thanks in advance,
Itty
Click to expand...

Start Date: =Received_Date-WEEKDAY(Received_Date+3)+8
Delivery Date: =Start_Date + 9
or
=Received_Date-WEEKDAY(Received_Date+3)+17

You did not specify 9 workdays, only 9 calendar days. So the delivery date
will always be on a Saturday based on what you've posted.


--ron
 
Top