Create a date based on document type and issue date

SimonH · #1 09-06-2023, 05:39 PM

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

Alansidman · #2 09-10-2023, 07:50 AM

in column M.
=If(or(C2="Form",C2="Worksheet"),E2+365,E2+730)
This will work for your current example. If you have many types of documents, then you may wish to have a table of doc types and use the Vlookup function.

SimonH · #3 09-10-2023, 06:10 PM

thank you for that

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Use Original Award Date or Mod Award Date For Date-Based Recurring Tasks	KBCasey27	Project	1	04-30-2021 12:22 AM
Calculate week in Word document based on date entered into same document	ArviLaanemets	Word VBA	4	11-18-2019 12:25 AM
Stamp a document with new Vol#, Issue#, and date	jeffreybrown	Word VBA	2	12-17-2018 06:21 PM
Want to use the DateAdd function to type text at a location in word document, using date from CC	corriganc	Word VBA	10	08-09-2017 08:07 PM
How can a document have the same date modified/create date, yes have have actual file content?	legaleagle	Word	15	01-07-2015 06:58 PM