Flagging this Month or Last Month

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.

Best Answer

  • Carson Penticuff
    Carson Penticuff ✭✭✭✭✭✭
    Answer ✓

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

Answers

  • Carson Penticuff
    Carson Penticuff ✭✭✭✭✭✭
    Answer ✓

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