Create a date based on document type and issue date
I have different document types and their review dates will vary according to type, 1 year or 2 years.
example, if a form or worksheet was issued today then the review date will be in 2 years. If a procedure then the review date will be 1 year from issue.
Col A is document type (currently 3, form, procedure and worksheet, ), Column B is Issued date and col C is revision due on.
Any help would be greatly appreciated.
Help Article Resources
Check out the Formula Handbook template!