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

Options

Have tried a few different formulas and not working

Best Answer

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

    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))

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!