Count days and weeks to include start date and end date

[Courtenay_Ricke]

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?

Thanks,

[Justin_Barrett]

Courtenay_Rickey:

it is not counting the end date, ie hire date of 12-Apr thru 16-Apr counts 4 days, not 5.

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.

Courtenay_Rickey:

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

Add 1 to the result:

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