Formula to calculate the days in between dates.

Maria M.

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?

Paul Newcome

What exactly are you trying to do?