Last Month Formula?

BThompson

I'm trying to develop a formula for a column that lets me know if the Event date in that row is "Last Month" or not. A simple 1 or 0 result for yes or no will work. I had put together what I thought would work using Date, Year and Month, but when we hit 2023, it failed. Looking for advice.

Mike TV

@BThompson

=IF(MONTH([Event Date]@row) = MONTH(DATE(YEAR(TODAY()), MONTH(TODAY()), 1) - 1), 1, 0)

Mike TV

@BThompson

=IF(MONTH([Event Date]@row) = MONTH(DATE(YEAR(TODAY()), MONTH(TODAY()), 1) - 1), 1, 0)

Mike TV

Credit to @Paul Newcome for the formula found on this thread which I altered to make it work here.

https://community.smartsheet.com/discussion/68478/date-formula-for-last-month-last-quarter-last-year

BThompson

Mike TV, works perfectly! Thanks so much!!!

Brooke Weber

Hello @Mike TV ! I'm curious how to get this to work when the Date column is a formula? I get an error when using this formula as "#Invalid Data Type" when referring to a date column that is populated by a formula; however, it works when a date is manually entered. Any suggestions?

Genevieve P.

Hi @Brooke Weber

What is the formula you're using to create the date? It sounds like the output may be seen as text instead of a date-type of value.

MPath

https://community.smartsheet.com/discussion/comment/356311#Comment_356311

But when january hits, won't this be an issue? since that month is 1 and 1 -1 =0 and month 0 does not exist.

Paul goes into detail in the thread you mention, but it concerns rolling quarter reporting.