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?
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 yearB Moderate – 2 yearC Non-Critical – 3 yearD Trivial – N/AHow do I write a formula to do this? Read More
