Formula to return the first day of the month for the prior 13 months?

Options

I'm building a rolling 13 month graph and I need a formula that will take today's date and provide me with the first day of the prior month, first day of 2 months ago, first day of 3 months ago, etc. so that I can then do a lookup from my master sheet to pull the right data from those respective months. The formula would go in the MM-YY column. Thanks!


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!