Yes you got it right in saying "16/10/2008 minus 14/08/2008".

If your dates are in A2 and B2 respectively, the formula for the number of
days is =A2-B2. The explanation is that Excel dates are stored as a number
of days from an origin at the start of 1900 (or of 1904, depending on which
options you have set).

Note that when you ask a question in a newsgroup, the answer comes in the
newsgroup, not by e-mail. The reason for that is so that the answer can be
of use to other readers of the group (and so that other contributors can
correct me when I've got it wrong).
--
David Biddulph

"RAJ KAPADIA, SURAT, INDIA" <RAJ KAPADIA, SURAT,
wrote in message
...
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?