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?
Help Article Resources
Check out the Formula Handbook template!