Formula to calculate the days in between dates.


Hello I have a formula that will work with November dates or a November and December date but not with both December dates in the End bill date and Start bill date.

=(([End Bill Date]@row - [Start Bill Date]@row) + 1) / (DAY(DATE(YEAR([End Bill Date]@row), MONTH([End Bill Date]@row) + 1, 1) - 1))

I have formatted the Start Bill Date and End Bill date to be date columns.

The Formula just wont work with December dates. Why is that?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!