I want to add a column that lists dates 6 months from other date column


Have tried a few different formulas and not working

Best Answer

  • Carson Penticuff
    Carson Penticuff ✭✭✭✭✭✭
    Answer ✓

    You can try putting this in. It is just the same formula with the IFERROR() removed. If that results in errors in those same cells, the date in that specific row may not be formatted correctly.

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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!