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-10-2023, 07:50 AM

Alansidman Alansidman is offline

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

Office 2021

עַם יִשְׂרָאֵל חַי

Join Date: Apr 2019

Location: Steamboat Springs

Posts: 121

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.

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 02:02 PM.