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