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