Add years to date Formula

This discussion was created from comments split from: Add years to a date.


  • Lori C
    Lori C ✭✭

    Hello All,

    Here is my current formula and it is working great, expect 2024 is fast approaching and I need to add the year to my formula to get the new data. How would I add the year to this formula?

    =SUMIFS({Rounding| Number of Staff Contacts}, {Rounding| CPD Educator Name}, Category@row, {Rounding |Date Rounding Occurred}, AND(IFERROR(MONTH(@cell), 0) = 7))

    Thank you for any help,


  • Nick Korna
    Nick Korna ✭✭✭✭✭✭

    Hi @Lori C,

    You would amend the last portion of your formula (for example for Jan 2024):

    =SUMIFS(...AND(IFERROR(MONTH(@cell), 0) = 1, IFERROR(YEAR(@cell), 0) = 2024))

    Hope this helps, but let us know if there are any problems!

  • Lori C
    Lori C ✭✭

    It worked!

    Thank you

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!