Microsoft Office Forums - View Single Post - Create a date based on document type and issue date

Thread: Create a date based on document type and issue date

View Single Post

Old

09-10-2023, 07:50 AM

Alansidman Alansidman is offline

Alansidman is offline

Alansidman uses Windows 11

Windows 11 Alansidman uses Office 2021

Alansidman uses Office 2021

Office 2021

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

Join Date: Apr 2019

Location: Steamboat Springs

Posts: 81

Alansidman will become famous soon enough

Alansidman will become famous soon enough

Default

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.

Reply With Quote