calculating with dates

D

DzEK

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 attention!!


PS using excel 2000
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

calculating with dates 6
Problem formatting dates from CSV file 2
Excel DateDif - why does 2007 seem different? 3
Number of years/months/days between 2 dates 4
Average days between dates 3
Excel Help with dates 2
Calculating Dates in Terms of Months 4
How do I calculate the difference between 2 dates (m,d,y) ? 8

Top