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_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:
> >
> > > I need a formula to count days between two dates
> > > (in cells) that would include leap years
> > >
> > > any help ??
> > >
> > > Thanks Larry
> > >
> > >
> > >
|
Similar Threads
