i want add a date automatic 6 months before the date show.

Options

I Read through a number of posts, unable to find the right answer. I need some help to check if i want to purpurate the date as 6 months for the date below showing, how should i do the formula?

cheers,

Rane

Best Answer

  • Protonsponge
    Protonsponge ✭✭✭✭✭
    Answer ✓
    Options

    Hello @Rane Yan

    I think the following formula will work out for you.

    =IFERROR(IFERROR(DATE(YEAR([Renewal Completion Date]@row), MONTH([Renewal Completion Date]@row) - 6, DAY([Renewal Completion Date]@row)), DATE(YEAR([Renewal Completion Date]@row) - 1, MONTH([Renewal Completion Date]@row) + 6, DAY([Renewal Completion Date]@row))), " ")

Answers

  • Protonsponge
    Protonsponge ✭✭✭✭✭
    Answer ✓
    Options

    Hello @Rane Yan

    I think the following formula will work out for you.

    =IFERROR(IFERROR(DATE(YEAR([Renewal Completion Date]@row), MONTH([Renewal Completion Date]@row) - 6, DAY([Renewal Completion Date]@row)), DATE(YEAR([Renewal Completion Date]@row) - 1, MONTH([Renewal Completion Date]@row) + 6, DAY([Renewal Completion Date]@row))), " ")

  • Rane Yan
    Options

    Hi Protonspounge,

    this is working well! Thanks so much!

    Best Regards,

    Rane

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!