finding date difference

[Totti]

I have a Column which contains different dates more than 1000 records
I have to find the Date difference as on for a specific day (assume
=today()) .

The answer should return how much years, months and days have
passed since then.
example :- I am born on 10/04/1983 and today is 15/10/2008 . I want to
know how
many years, months and days have passed since my birthday(without
auxiliary columns).

and something else if my reader knows any good document on how to use
datediff in excel please tell me the link!

Any help appreciated

 

[Peo Sjoblom]

http://www.cpearson.com/excel/datedif.aspx

--


Regards,


Peo Sjoblom

 

[Mike H]

Hi,

Try,

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

have a look here for datedif but this doesn't document a flaw in the
function that can give incorrect results. For example try

1 March 2006
31 January 1988
=17 years, 1 months, -2 days

http://www.cpearson.com/excel/datedif.aspx

Mike

 

[Ron de Bruin]

Hi Totti

After you see Chip's page (See the link Peo posted) you can see if you like this add-in

DataRefiner have a option to insert a column with formulas that give you this result
Maybe you like it

http://www.rondebruin.nl/datarefiner.htm