[RESOLVED] ages

in excel i am using this formula to work out someones age,

=INT($B$2-C11)/365.25
where $b$2 is todays date and c11 is the DOB

but it rounds it up so if they are 15 and a half it puts that they are sixteen, how can i force excel to round down.

thanks
joe

Use this formula:

Code:

---

=IF(MONTH(C11)<MONTH($B$2);YEAR(C11)-YEAR($B$2)-1;IF(MONTH(C11)=MONTH($B$2);IF(DAY(C11)>=DAY($B$2);YEAR(C11)-YEAR($B$2)-1;YEAR(C11)-YEAR($B$2))))

---

Or:

=INT(($B$2-C11+1)/365.25)

i have tried both of these methods and neither of them seem to work, am i doing something wrong?

any other suggestion?

thanks joe

My one works for me. How does yours not work? Give an example of what you have put in the cells.

sorry i have got it to work now thanks

Quote:

---

in excel i am using this formula to work out someones age,

=INT($B$2-C11)/365.25
where $b$2 is todays date and c11 is the DOB

but it rounds it up so if they are 15 and a half it puts that they are sixteen, how can i force excel to round down.

thanks
joe

---

Hi Joe

You can also use the above formula as

=INT((TODAY()-C11)/365.25)

Where C11 is the DOB and Today() gives you todays date...

Even in my case Excel rounds 15.5 to 15

Just try this in any cell and tell me what do you get?

=INT(15.5)

yeh it rounds down but i have got it sorted now, thanks alot anyway.

thanksalot everyone

joe

i used this code and just copied it down into everycell,

Code:

---

=IF(C11="","",INT(($B$2-C11+1)/365.25))

---

Here is an accurate way to find the DOB ;)

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

A1 = DOB

why would you want to get somebodys date of birth though from their age, because nobody knows how old they are exactly, or am i not understanding it right?

Quote:

---

Here is an accurate way to find the DOB

---

sorry that's a typo... :blush:

It should be

Quote:

---

Here is an accurate way to find the Age

---

so how is it more accurate than

Code:

---

INT(($B$2-C12+1)/365.25)

---

as this seems to work fine?
or does yours return their age in years, months and days?

Quote:

---

as this seems to work fine?
or does yours return their age in years, months and days?

---

Yes it does