Manipulating a date

cvc.lukes

Ideally what I'm trying to do is take a date in a cell and add 5 months to it. I've looked here to find answers and found multiple options. Everything is giving me an "#INVALID COLUMN VALUE"

Here is what I've tried so far

=IFERROR(DATE(YEAR(Start@row), INT(MONTH(Start@row) + 5), DAY(Start@row)), DATE(YEAR(Start@row) + 1, MONTH(Start@row) - 7, DAY(Start@row)))

I broke out the start into a column for month, day, year. Added 5 to the month

=DATE(VALUE(Year@row), VALUE(Month@row), VALUE(Date@row))

I tried to make the 5 month increase a cell to reference, instead of calling out a static 5 like in the first formula.

=DATE(YEAR(Start@row), MONTH(Start@row) + Static@row, DAY(Start@row))

Looking for tips or advice in what I'm doing wrong. The community threads I've found on this everyone seems to be getting these to work when some how I'm not.

Paul Newcome

Give this a try:

=IFERROR(DATE(YEAR(Start@row), MONTH(Start@row) + 5, DAY(Start@row)), DATE(YEAR(Start@row) + 1, MONTH(Start@row) - 7, DAY(Start@row)))

Make sure the column you are putting this in is set as a date type column.