I am attempting to use a date in a column to calculate 6 months after that date into another column


My formula works as long as it is in the original date is in the first 6 months of the year, but if it is in the last half of the year, my formula is not looping to the next year.

Example: I need 6 months from 08/01/2022 which would be February of 2023

Here is the formula I have been using: =DATE(YEAR([Approval Date]1), MONTH([Approval Date]1) + 6, DAY([Approval Date]1))


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!