DATE Formula help

System

This discussion was created from comments split from: How to create a formula to show last day of the month.

damon.tackett

great formula but I am looking for a slight tweek.

I have two columns. Date Requested and Date Expires

I need the Date Expires column to reflect the date in the Date Requested column PLUS two years

So:

Date Requested Date Expires

12/20/2023 12/31/2023

I used this formua: =DATE(YEAR([Date Requested]@row) + 2, MONTH([Date Requested]@row), DAY([Date Reqeusted]@row)) and it gets the year right, but I can't figure out the Day part

Paul Newcome

@damon.tackett Do you mean you want the last day of the month two years after the [Date Requested]?

damon.tackett

@Paul Newcome Correct. So if in my Date Requested column the date is 12/20/2023 in my Date Expires column it updates it to 12/31/2025.

I see that I forgot to update the year on my previous example. Sorry about that.

Paul Newcome

Try this:

=IFERROR(DATE(YEAR([Date Requested]@row) + 2, MONTH([Date Requested]@row) + 1, 1), DATE(YEAR([Date Requested]@row) + 3, 1, 1))