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 dont know how to calculate future date based on condition.
Thanks in advance for your assistance
Bookmarks