[RESOLVED] ages

[jbaldwinroberts]

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

[opus]

Use this formula:

=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))))

[zaza]

Or:

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

[jbaldwinroberts]

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

any other suggestion?

thanks joe

[zaza]

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

[jbaldwinroberts]

sorry i have got it to work now thanks

[Siddharth Rout]

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)

[jbaldwinroberts]

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

thanksalot everyone

joe

[jbaldwinroberts]

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

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

[Siddharth Rout]

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

[jbaldwinroberts]

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?

[Siddharth Rout]

Here is an accurate way to find the DOB

sorry that's a typo...

It should be

Here is an accurate way to find the Age

[jbaldwinroberts]

so how is it more accurate than

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

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

[Siddharth Rout]

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

Yes it does