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

any help ??

Thanks Larry

Hi Larry you could use the function DATADIFF as

=DATADIF(initial_date,final_date,"type_of_differen e")

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:

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

any help ??

Thanks Larry

sorry the correct function is DATEDIF....

I type it on Portuguese sorry



"Marcelo" escreveu:

Hi Larry you could use the function DATADIFF as

=DATADIF(initial_date,final_date,"type_of_differen e")

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:

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

any help ??

Thanks Larry

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

Marcelo wrote:
sorry the correct function is DATEDIF....

I type it on Portuguese sorry



"Marcelo" escreveu:

Hi Larry you could use the function DATADIFF as

=DATADIF(initial_date,final_date,"type_of_differen e")

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:

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

any help ??

Thanks Larry