how to add 12 months to a date and in a new cell

ShaunW

I have a fixed date and am trying to add 12 months to the date and show it in a different cell, any ideas on the formula?

Jeff Reisman

Let's say your columns are Date and NewDate.

In your NewDate column try this:

=DATE(YEAR(Date@row)+1, MONTH(Date@row), DAY(Date@row))

The DATE function builds a valid date format value from numeric values in year, month, day order, separated by commas. Syntax is: DATE(year, month, day). In this case, using the YEAR, MONTH, and DAY functions to pull the values from the Date column.

Or you could just use

=Date@row + 365

but this won't account for the extra day in those pesky leap years.

ShaunW

This worked great, many thanks, also manage to figure out if you want 18 months just place + 6 after the month statement, i'm rocking now 😀

Jeff Reisman

@ShaunW Glad I could help.

(If you could mark my answer as accepted, I'd appreciate it!)

Jeff Reisman

Let's say your columns are Date and NewDate.

In your NewDate column try this:

=DATE(YEAR(Date@row)+1, MONTH(Date@row), DAY(Date@row))

The DATE function builds a valid date format value from numeric values in year, month, day order, separated by commas. Syntax is: DATE(year, month, day). In this case, using the YEAR, MONTH, and DAY functions to pull the values from the Date column.

Or you could just use

=Date@row + 365

but this won't account for the extra day in those pesky leap years.

ShaunW

This worked great, many thanks, also manage to figure out if you want 18 months just place + 6 after the month statement, i'm rocking now 😀

Jeff Reisman

@ShaunW Glad I could help.

(If you could mark my answer as accepted, I'd appreciate it!)