what formula to get how longer from date

[ykn]

if (B2 is 01 April 2006) and (B3 is 31/05/2009), what formula can i use to
get how long in between this two date?

 

[Dave Peterson]

If those values are really dates, then you can use:

=b3-b2
(and format as General)
to get the number of days between the dates.

If you want years, months, days, then look at Chip Pearson's site:
http://www.cpearson.com/excel/datedif.aspx

 

[FARAZ QURESHI]

Use
=Datedif(<<Beginning Date>>,<<Ending Date>>,"D")
for calculating difference in days,
=Datedif(<<Beginning Date>>,<<Ending Date>>,"M")
for calculating difference in months,
=Datedif(<<Beginning Date>>,<<Ending Date>>,"Y")
for calculating difference in years.

 

[Shane Devenshire]

Hi,

the main problem with DATEDIF is Microsoft doesn't document it (except in
version 2000).

But in your case Dave's solution is shorter.