Create a date based on document type and issue date

		Microsoft Office Forums > Microsoft Excel > Excel
Create a date based on document type and issue date

FAQ

Thread Tools

Display Modes

09-06-2023, 05:39 PM

SimonH

Windows 11 Create a date based on document type and issue date

Office 2021

Novice

Join Date: Sep 2023

Posts: 2

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

Screenshot 2023-09-06 134230.jpg (34.9 KB, 13 views)

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