IF formula for previous date

Options

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", ""

Tags:

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!