finding the difference in years between dates

G

Guest

Hi
I need a formula which will work out the difference in
years between two dates to calculate age.
For example if I type 8/8/1984 into A1 and 8/9/2004 into
A2 I need a formula which will show 20 in A3.
 
B

BadgerWI

Would subtracting one number from the other and dividing by 365 give you the
same answer?
 

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

Difference between dates 9
Difference between two date/time values 5
Networkdays function doesn't find true difference between two dat 6
Can you calculate the number of years between two dates in Excel 0 4
Calculate difference between current date & prior 3
Difference between date and time 7
difference of date/time only calculating workingdays/hours 4
help with datedif function please 4

Top