Calculation of future date based on condition

**ashokdc** · 02-26-2011, 03:11 AM

Dear friends,

I would appreciate if you kindly help me to prepare an excel sheet to calculate future date based on condition, the details of that I have mentioned below:

When I receive task from Client “X” I have to deliver it after 7 working days
When I receive task from Client “Y” I have to deliver it after 7 calendar days
When I receive task from Client “Z” I have to deliver it after 2 Months

If I select Clients from dropdown list (eg. X,Y,Z) automatically the Number of days to deliver will be populated (eg. 7 working days, 7 calendar days, 2 months) and then if I enter the receive date the delivery date will be populated automatically based on clients.

I know how to create dropdown, also calculate working days and calendar days but don’t know how to calculate future date based on condition.

Thanks in advance for your assistance

**zbor** · 02-26-2011, 03:34 AM

Try is this ok:

=LOOKUP(A2,{"X","Y","Z"},C2+{10,7,62})-IF(A2="X",2*(WEEKDAY(C2,2)<6),0)

**ashokdc** · 02-26-2011, 04:11 AM

Originally Posted by zbor

Try is this ok:

=LOOKUP(A2,{"X","Y","Z"},C2+{10,7,62})-IF(A2="X",2*(WEEKDAY(C2,2)<6),0)

Hi,
Its working fine. many many thanks.
I need one more help in the same sheet
If i select the client in A2 field , days to deliver should be populated automaticaly in field B2
How to get that.

**zbor** · 02-26-2011, 04:13 AM

Remove C2 from formula:

=LOOKUP(A2,{"X","Y","Z"},{10,7,62})-IF(A2="X",2*(WEEKDAY(C2,2)<6),0)

**ashokdc** · 02-26-2011, 05:15 AM

Originally Posted by zbor

Remove C2 from formula:

=LOOKUP(A2,{"X","Y","Z"},{10,7,62})-IF(A2="X",2*(WEEKDAY(C2,2)<6),0)

Thank you verymuch.
Its working.

**teylyn** · 02-26-2011, 05:46 AM

Moved to Excel Worksheet Functions.

@ashokdc,

before you post your next question, please make sure to read the forum rules and post into a question forum. The Tip.com Feedback forum is not for Excel questions.