Add years to date Formula

System

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

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,

Lori

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

It worked!

Thank you