in excel i want to calculate days between two dates

for e. g.

16/10/2008 minus 14/08/2008
(dd/mm/yyyy)

please explain and if possible give me an example.

my alernate email address is



please help me out

thanks

=raj kapadia, surat, india

"Bob Phillips" wrote:

=DATEDIF(A1,NOW(),"y") & " years, " & DATEDIF(A1,NOW(),"ym") & " months, " &
DATEDIF(A1,NOW(),"md") & " days"
--

HTH


RP
(remove nothere from the email address if mailing direct)


"Pate" wrote in message
...
We are using Excel as a manual log of visits. We would like to screen out
anyone that is not 18 years old and were looking for a means of
calculating
the age from the current date and the date of birth. Is there a function
that
can do this?