calculating with dates

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

want to calculate the difference between two dates
and necesarry to see the result separated by years / months / days
but dont know how??

for example: 20/05/2005 - 10/03/1990 = 15 years/ 2months/ 11days

thanks for your attention!!


PS using excel 2000


.

Relevant Pages

  • RE: How do I import several text files into excel or access ?
    ... > I receive hundreds of text files daily that i have to convert to excel. ... > can I automate the process so that i dont have to manually open every text ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • Re: Code Help ^
    ... If i was familiar with VB and Excel i could easily put your ideas to ... but i really dont know very much about how to do these things... ... ChasePenelli's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=24619 ... Prev by Date: ...
    (microsoft.public.excel.programming)
  • Help (cesar code)
    ... I am having a little problem, i know what i want to do with excel but i ... dont no where to start, i dont no what formula to use, what i am after ... is a spreadsheet to encrypt and decrpt 'cesar code'. ... Prev by Date: ...
    (microsoft.public.excel.programming)
  • How do I import several text files into excel or access ?
    ... I receive hundreds of text files daily that i have to convert to excel. ... can I automate the process so that i dont have to manually open every text ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • last entry done in certain area
    ... i have a big database in excel.. ... dont want to go last and first... ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)