Hi Everyone,
Would like to seek help on some Excel sheet Im working on.
Basically what I want is to automatically change a target date depending on the Severity of the Issue.
On the image provided, On Column C is the Severity, Column D I called the Last Date of Update, Column E is my Target date.
It should return as below:
Severity is High
Taget Date (Column E) = Date of Last Update(Column D) + 2 Years
Severity is Moderate
Taget Date (Column E) = Date of Last Update(Column D) + 4 Years
Severity is Low
Taget Date (Column E) = Date of Last Update(Column D) + 5 Years
Hope Someone can help me with this? Thank you very much.
Vincent
Bookmarks