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

Options

=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!!

Tags:

Options

Perfect

Thanks Kelly

• ✭✭✭✭✭✭
Options

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

• Options

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

• ✭✭✭✭✭✭
Options

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