count days

[Larry]

I need a formula to count days between two dates
(in cells) that would include leap years

any help ??

Thanks Larry

 

[Marcelo]

Hi Larry you could use the function DATADIFF as

=DATADIF(initial_date,final_date,"type_of_differene")

type of difference could be:
"Y" - # of completed years between dates
"M" - # of completed months bt dates
"D" - # of completed days bt dates
"MD" - Months and Years are ignorated
"YD" - Days and Years are ignorated

hope it helps

regards from Brazil
Marcelo



"Larry" escreveu:

 

[Marcelo]

sorry the correct function is DATEDIF....

I type it on Portuguese sorry



"Marcelo" escreveu:

 

[Pete_UK]

If you just want the answer in days, then you only need to subtract one
from the other and format the cell as Number with zero decimal places,
i.e.:

=B1 - A1

if B1 contains the later date and A1 the earlier date.

Hope this helps.

Pete