Counting the number of days between two date

[Maddoktor]

Hi all,

I was wondering if someone could help me by providing the formula to count
the number of days between two dates. i.e. 1/6 to 2/6 ... by subtracting one
from another the answer will be 1. I would like for the formula to count the
first date (1/6) and then count the days. Therefore, the answer to the
number of days from the 1/6 to 2/6 equals 2 (including 1/6).

Thanks in advance.

 

[JE McGimpsey]

One way:

A1: 1/6
B1: 2/6
C1: =B1-A1+1