Formula help for previous month

Ryan Murphy · 11/06/19

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 · 11/06/19

Try something like this...

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

paddy · 01/05/23

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 · 01/05/23

@paddy Try this:

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

paddy · 01/05/23

@Paul Newcome Awesome! Thank you so much.

Paul Newcome · 01/05/23

@paddy Happy to help. 👍️

Ami Veltrie · 01/11/23

@Paul Newcome You're the best!

Cesar Perez · 01/27/23

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

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

Thank you,

Paul Newcome · 01/27/23

@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 · 01/27/23

Thank you @Paul Newcome

Ami Veltrie · 01/05/24

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

Formula help for previous month

Answers

Help Article Resources

Categories