Count days and weeks to include start date and end date

Hi Community - probably super simple, but I have looked through and done searches but I still can’t figure it out.
I’m using DATEDIFF to find the number of days between two rental dates, but it is not counting the end date, ie hire date of 12-Apr thru 16-Apr counts 4 days, not 5.

I think the same goes for outing weeks too. Any solutions please?


Correct. The logic there is that if you wanted to add the counted days to the original, you would add 4 days to go from the 12th to the 16th.

Add 1 to the result:

DATETIME_DIFF({End Date}, {Start Date}, "days") + 1
1 Like

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.