Date counting formula

[Guest]

What is the formula to count the number of days only
between two dates

 

[Domenic]

Hi,

try DATEDIF(start_date,end_date,"D")

For example,

=DATEDIF("6/10/2004","6/12/2004","D")

Hope this helps!

 

[Frank Kabel]

Hi
just subtract the date values (and maybe adjust accordingly to include
or exclude these dates).
e.g.
A1=06/01/2004
A2=06/03/2004

Now use the following formula in A3
=A2-A1
and format this cell as number.
This would return '2'. If you only want to count the numbers between
both dates use
=A2-A1-1