Trying to get the last day of the next month based on another date column's value...


Hello, Community!

Current formula (returns the first day of the next month) works:

=DATE(YEAR([Earnings End Date]@row), MONTH([Earnings End Date]@row) + 1, 1)

I'm trying though to have it return 7/31/23 instead of 7/1/23...what am I missing?


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!