IF formula for previous date


I see a lot of "countifs" solving this which is great except I need a straight IF formula....

I am trying and failing to come up with a formula that tells me if something occurred the month previous.

For Example:

IF [Occurrence Date] was previous month, "Previous Month", ""


Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!