#1
|
|||
|
|||
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 |
#2
|
||||
|
||||
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. |
#3
|
|||
|
|||
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 |