I am trying to add 5 years to a date
I am using the following formula
=DATE(YEAR([Activation Date]@row) + 5, MONTH([Activation Date]@row), DAY([Activation Date]@row))
The Activation Date column is set to a Date column Type
The receiving column (Expiration Date) is also set to a Date column Type
I am getting an error #UNPARSEABLE
Help Article Resources
Check out the Formula Handbook template!