Forum Discussion
How to update date depending on cell text
We have a requirement to forecast when a supplier is next due for an audit.
In column A we have the classification, A Critical, B Moderate, C Non-Critical and D Trivial.
In column B we have the date of the last audit.
In column C I would like to have the spreadsheet automatically forecast the date when it is next due.
A Critical - 1 year
B Moderate - 2 year
C Non-Critical - 3 year
D Trivial - N/A
How do I write a formula to do this?
As a variant to Martin_Angosto 's solution, this would work as well.
=EDATE(B1,LOOKUP(A1,{"C","M","N","T"},{12,24,36}))Hi, please see attached document with proposed formulation. Do not forget to format cells in column C as dates.
