What formula do I use to add 12 months to a date?

Kim Mauger

I have created a smartsheet form for contractor inductions. In one of the columns is the date at which the contractors completed induction was reviewed internally. I now need to create a formula that automatically populates the cell with a date that is 12 months from the review date as this will highlight when the contractor next has to be reviewed.

I'm having trouble making a formula work. Can you help me with this?

Andrée Starå

Hi Kim,

Try something like this.

=DATE(YEAR([Review Date]@row) + 1; MONTH([Review Date]@row); DAY([Review Date]@row))

The same version but with the below changes for convenience.

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

Depending on your country/region, you'll need to exchange the comma to a period and the semi-colon to a comma.

Did that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Kim Mauger

Hello Andree,

Thank you for your reply. I have tried the formulas both ways and they return an error message - #UNPARSEABLE with the semi-colan, and #INVALID COLUMN VALUE with the comma.

Do you have any other suggestions?

Thanks,

Kim Mauger

Andrée Starå

Happy to help!

That is strange!

Have you changed the column name to match yours?

Kim Mauger

Yes I made sure the column name matched exactly.

Andrée Starå

Ok.

Can you maybe share the exact formula, sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

Kim Mauger

Hello Andree,

Here is a screenshot of the columns. My date format is also dd/mm/yy which may have an impact on the formula.

Paul Newcome

Double check that the column you are putting your formula in is set to a Date type column.

Andrée Starå

@Kim Mauger

I agree with Paul. Doublecheck the columns.

Kim Mauger

Ah yes thank you, I've change the column properties to date type and this works now :)

Andrée Starå

@Kim Mauger

Excellent!

Happy to help!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Paul Newcome

Happy to help! 👍️

Becky Wilson

I'm trying to add 5 years to a date using your formula and I get and Unparseable error

Paul Newcome

@Becky Wilson Can you copy/paste the formula that is causing the error exactly as is directly from the sheet to here?

Becky Wilson

=DATE(YEAR([Activation Date]@row) + 5, MONTH([Activation Date]@row), DAY([Activation Date]@row))

Becky Wilson

I am not sure exactly what happened, but now it works! Thanks