Formula to generate the expiration date, 1 year after date signed?

Justine Guido

I am trying to figure out a formula that can generate the "expiration" date based on the "date last signed". The "expiration" date is one year from "date last signed". Note, dependencies are off.

Example: If the "Date Last Signed" is 01/01/20 then the "Expiration" date should be 01/01/21. Seems pretty straight forward but cannot figure it out. Please help?!

Thank you, Justine

Ramzi K

@Justine Guido

In this example: Two columns Date1 and Date2

Use this formula in Date2 column:

=DATE(YEAR([Date1]@row) + 1, MONTH(([Date1]@row), DAY([Date1]@row)))

I hope this helps.

Ramzi

Ramzi K

@Justine Guido

In this example: Two columns Date1 and Date2

Use this formula in Date2 column:

=DATE(YEAR([Date1]@row) + 1, MONTH(([Date1]@row), DAY([Date1]@row)))

I hope this helps.

Ramzi

Justine Guido

It worked! Thank you so much!