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

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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