what formula to get how longer from date

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?

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

ykn wrote:

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

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.


"ykn" wrote:

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?

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.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"FARAZ QURESHI" wrote:

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.


"ykn" wrote:

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?