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

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

This is a duplicated post.