Date Formula Issue

Austin Burton

=DATE((YEAR[Tactical Training Start]@row), (MONTH[Tactical Training Start]@row) + 1, (DAY[Tactical Training Start]@row))

^^ This is the formula as it sits now. I'm trying to take the date from the Tactical Training Start column for a cell and add 1 month to the date for a different cell. What am I doing wrong?

Austin Burton

Mark Cronk

Try:

=DATE(YEAR([Tactical Training Start]@row), MONTH([Tactical Training Start]@row) + 1, DAY([Tactical Training Start]@row))

Mark