Flagging this Month or Last Month

Fboivin

I am trying to create a helper column to flag something as occuring "This Month" or "Last Month"

This is the formula I'm using.

=IF(Date@row = MONTH(TODAY()), "This Month", "Last Month")

It is saying #INVALID OPERATION. Not sure what I have wrong here.

Carson Penticuff

=IF(MONTH(Date@row) = MONTH(TODAY()), "This Month", "Last Month")

You were on the right track.

Will the current and previous months be the only options? Will there be entries from prior to last month?

Carson Penticuff

=IF(MONTH(Date@row) = MONTH(TODAY()), "This Month", "Last Month")

You were on the right track.

Will the current and previous months be the only options? Will there be entries from prior to last month?