date track based on svc cond. - open RO's

[Ken W - FLA]

Hello,

I'm looking to track material out for repair by the type
of service requested.
In cell (G:2) will be the type of service:

BCK = bench check = this will have a projected return
date (I:2)within three days of the repair order date (H:2)

REP = repaired = This will have a projected return date
(I:2) within 7 days of the repair order date (H:2)

OVH = overhaule = this will have a projected return date
(I:2) within 14 days of the repair order date.

With all this I would also like to include the warranty
schedule from the date of the service reurn date(J2)
BCK= no warranty
REP= 90 day warranty
OVH= 180 warranty

This is the date formula, =DATE(YEAR(I2)+1,MONTH(I2),DAY
(I2)-1, Norm from Australia kindly provided, but I do not
know how to add the rest that I would like to include or
even if its possible