If Conditions then Date

[Vincent.Eymard]

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

[zbor]

This maybe:

=DATE(YEAR(C1)+LOOKUP(B1,{"High","Low","Moderate"},{2,5,4}),MONTH(C1),DAY(C1))

Or this if you don't care about one day due to leap year

=C1+DATE(LOOKUP(B1,{"High","Low","Moderate"},{2,5,4}),1,)

However, both will give you error if none of criterai is written (High, Low, Moderate)

[Vincent.Eymard]

This maybe:

=DATE(YEAR(C1)+LOOKUP(B1,{"High","Low","Moderate"},{2,5,4}),MONTH(C1),DAY(C1))

Or this if you don't care about one day due to leap year

=C1+DATE(LOOKUP(B1,{"High","Low","Moderate"},{2,5,4}),1,)

However, both will give you error if none of criterai is written (High, Low, Moderate)

@zbor
You are a lifesaver, you have no idea how much this saved me a huge amount of time.
Thank you so very much, appreciate it. ^^