Hey,
I need help and not sure if it entirely possible.
I have a huge tracker, which needs to be filtered by Low, Medium and High. I have created a drop down list for these items, however these drop down lists need to contain a formula, which will deduct a certain amount of days from a start date.
For example
Low - deduct 14 days
Medium - deduct 30 days
High - deduct 60 days
For example: Column N - I have a start date of the 24/11/2022, I have selected a drop down list of a Low priority, I need excel to automatically deduct 14 days and input that date into another column.
Is that possible?
I hope this makes sense
Bookmarks