Need help: Calculation of due date based on condition.xlsx

[ashokdc]

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 help