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 dat...
As a variant to Martin_Angosto 's solution, this would work as well.
=EDATE(B1,LOOKUP(A1,{"C","M","N","T"},{12,24,36}))