how do I calculate years between two dates

G

Guest

I'm trying to calculate age between A1 ( TODAYS' DATE) and B1 customer's
birthday, but all the formulas that I write in C1 ( that's where I want the
age ) will give me for example 33.56, and if I take off the decimals then it
will ROUND UP to 34 and thats not the real age. I basically want a formula
that DOES NOT ROUND UP and gime JUST THE YEARS ( in this case 33). Thanks.
 
G

Guest

To get fraction year
c1=datedif(b1,a1,"m")/12
format c1 as number with two decimals
 

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

Calculate age 13
How do i Calculate minutes between two different dates 5
Calculate age with an end date 3
How do I calculate a person's age from date of birth and a date 2
Calculating Difference Between Two Dates Using Only Year 5
calculate age from today's date (changes daily) and birthdate 4
Calc'ing Age based on two dates 4
Calculate Age 5

Top