Formula help for previous month

Ryan Murphy

I have a helper column for a report that I want to check the box if the DATE cell is in the previous month.   Any help is appreciated!!

Paul Newcome

Try something like this...

 

=IF(MONTH([Date Column]@row) = MONTH(TODAY()) - 1, 1)

paddy

https://community.smartsheet.com/discussion/comment/225921#Comment_225921

@Paul Newcome Thanks for the tip. It worked, however, now after the year change it doesn't work for December when we're in January. Any idea how I can fix this?

Paul Newcome

@paddy Try this:

=IF(MONTH([Date Column]@row) = IF(MONTH(TODAY()) = 1, 12, MONTH(TODAY()) - 1), 1)

paddy

@Paul Newcome Awesome! Thank you so much.

Paul Newcome

@paddy Happy to help. 👍️

Ami Veltrie

@Paul Newcome You're the best!

Cesar Perez

https://community.smartsheet.com/discussion/comment/355990#Comment_355990

Hi @Paul Newcome, would you mind explaining how this formula works?

Thank you,

Paul Newcome

@Cesar Perez

If the MONTH of the date in [Date Column]@row is equal to 12 or the Month of TODAY minus 1 depending on the MONTH of TODAY, then output 1.

Cesar Perez

Thank you @Paul Newcome

Ami Veltrie

To take into account the year, see this thread: https://community.smartsheet.com/discussion/comment/412060#Comment_412060