Thread: Create a date based on document type and issue date
View Single Post
 
Old 09-06-2023, 05:39 PM
SimonH SimonH is offline Windows 11 Office 2021
Novice
  
Join Date: Sep 2023
Posts: 2
SimonH is on a distinguished road
Default 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. Eventually there will be 6 or 7 document types.

See attachment for sheet layout .

Any help with the formula would be greatly appreciated.

Thanks

Simon
Attached Images
File Type: jpg Screenshot 2023-09-06 134230.jpg (34.9 KB, 13 views)
Reply With Quote