Formula Stopped Working


I've been using the below formula to calculate how many months have passed between dates (a single day in a month should have that month counted). It's been working perfectly for months, but recently I switched one of the columns from automatic population to manual (otherwise, no changes). It's now returning odd values, for example, my Date Opened and Date Closed both fell in March, and it returned a value of 3. Opened in March closed the previous January gives a value of 12, but closed in February gives 2 months. I have no idea what happened, and nothing I'm trying is fixing it. Any ideas?

=MONTH(([Date Closed]@row) - MONTH([Date Opened]@row) + ((YEAR([Date Closed]@row) - YEAR([Date Opened]@row)) * 12) + 1)


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!