I want to add a column that lists dates 6 months from other date column

AnneMarie_1990_

Have tried a few different formulas and not working

Carson Penticuff

You can try putting this in. It is just the same formula with the IFERROR() removed. If that results in errors in those same cells, the date in that specific row may not be formatted correctly.

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

Carson Penticuff

=IFERROR(DATE(YEAR([First Date]@row), MONTH([First Date]@row) + 1, DAY([First Date]@row)),"")

This one should work. You will need to change [First Date] to whatever your date column name. You will also need to ensure that both the [First Date] column and the column you want the +6 month date to appear in are both formatted as dates. The IFERROR() is in place in case there are any blank cells somewhere in the column.

AnneMarie_1990_

Thanks Carson, that worked!

But its still not dropping in for some cells in the column and im not sure why?

Carson Penticuff

You can try putting this in. It is just the same formula with the IFERROR() removed. If that results in errors in those same cells, the date in that specific row may not be formatted correctly.

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

AnneMarie_1990_

Worked! Thanks Carson!

Carson Penticuff

Happy to help, I'm glad it worked!

AnneMarie_1990_

Hi again,

another issue - if the +6 months runs into the next year, its coming up as an error. Any idea how to solve this?

Carson Penticuff

I failed to take into account wrapping into the next year. The first formula is for one month into the future, the second is for six months.

=IF(MONTH([First Date]@row) = 12, DATE(YEAR([First Date]@row) + 1, 1, DAY([First Date]@row)), DATE(YEAR([First Date]@row), MONTH([First Date]@row) + 1, DAY([First Date]@row)))

=IF(MONTH([First Date]@row) > 6, DATE(YEAR([First Date]@row) + 1, MONTH([First Date]@row) - 6, DAY([First Date]@row)), DATE(YEAR([First Date]@row), MONTH([First Date]@row) + 1, DAY([First Date]@row)))

AnneMarie_1990_

Worked - Thank you!!