Calculate Future Date

ggeorge

I need to calculate a due date that is 18 months out. I have a column for "Actual Run Date" and I have a column for "Expiry Date" so the "Expiry Date" column needs to automatically calculate an 18 months expiry date once I enter the date on the "Actual Run Date".

For example: if the "Actual Run Date" happened on 07/13/17 then the "Expiry Date" column should automatically populate the date 01/13/2019

Any help will be much appreciated

Thanks!

Mike Wilday

Do you need only the month number to change? Can you use #of days to calculate a near target date? 

=[Actual Run Date]23 + 547.5 

Putting that in the Expiry date column should get you close to 18 months... if you want to calculate the exact month you could deconstruct the date. 

Otherwise, the calculation could get pretty tricky.