Did a date formula change?


=DATE(YEAR([Last Month]@row) - 1, MONTH([Last Month]@row), 1)

=DATE(YEAR([Current Month]@row), MONTH([Current Month]@row) - 1, 1)

I have been using this above formula for the last 6+ months in 20+ sheets but I noticed it is not working anymore. Did something change or do I need to update something since the year changed?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!