Subtracting one date from another is always going to give that result.
It's the same as subtracting one number from another. If you want
inclusive, you will have to add one back or subtract the day before the
start day.

Kenneth Green wrote:

Hi Biff

If I wanted to use a formual to count days including the start date and end
dates what would i use?

e.g days between january 1, 2009 - january 7, 2009 is seven days, but using
the formulas it gives a result of 6 instead of seven

Thanks
Ken