Previous Month Forumla

Options

I would like to populate a series of dates based on the current date. Excell has the function EOMONTH that would work perfect, but it doesn't seem to work in smartsheet. I tested the formula "=EOMONTH(B4,-2)+1" and this gives me what I want. Any thoughts on how to create this in smartsheet?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!