Need a Formula to Show if Current Month & Year (in a checkbox)

Steve Dearing

Current Month and Year.PNG

=IFERROR(IF(AND(MONTH(TODAY) - MONTH(Date@row) = 0, (YEAR(TODAY) - YEAR(Date@row) = 0)), 1, 0))

Hi

I want to check the "Current Month & Year" column from the Date column if true, so I can roll reports and data for next year.

Not sure if my attempt is close or not!!

Thanks in advance.

Steve Dearing

Perfect

Thanks Kelly

Kelly Moore

Hey @Steve Dearing

Yes, only a small tweak is needed. Your TODAY function needs to be written as TODAY(). Also, the IFERROR function is wrapped completely around another function or formula. First write your formula, parentheses and all, then wrap the IFERROR around it. You must designate what happens in the event of error.

Your formula logic will work perfectly. I'll offer another approach

=IFERROR(IF(AND(MONTH(Date@row)=MONTH(TODAY()), YEAR(Date@row)=YEAR(TODAY()), 1),"")

Will this work for you?

Kelly

Steve Dearing

Hi Kelly

used your approach and came back with "incorrect argument set"

=IFERROR(IF(AND(MONTH(Date@row) = MONTH(TODAY()), YEAR(Date@row) = YEAR(TODAY()), 1), ""))

Steve

Kelly Moore

grrr. my bad. I rushed and didn't close the AND clause.

=IFERROR(IF(AND(MONTH(Date@row) = MONTH(TODAY()), YEAR(Date@row) = YEAR(TODAY())), 1), "")

Steve Dearing

Perfect

Thanks Kelly