Helper column formula to identify if "Month Requested" was the previous month
I really thought I had this one but I am getting an INCORRECT ARGUEMENT error.
I have created a help column to flag if the "month requested" value in my sheet is the Previous Month. I need to flag rows that are previous month to use in a filter for a report as I will be sending the report out the first day of the month for the previous month automatically.
Here's my formula:
=IF(MONTH([Month Requested]@row = MONTH(TODAY()) - 1, "Previous Month", ""))
If the Month Requested is the previous month I would like to see "Previous Month" returned, otherwise it would be blank.
What am I doing wrong? Thanks!
Help Article Resources
Check out the Formula Handbook template!