# Age between two dates

I have a spreadsheet where column b is the birthdate and I need to determine the age of the person relative to august 31 of 2011.
Cluskitt

=2011-YEAR(B1)-IF(MONTH(B1)>8,-1,0)
Change the -IF to +IF
Or change the -1,0 to 1,0 in the if.
Either way should work
Matt Pinkston

it comes back with a werid date 1/12/1900

I was hoping for just how of the indivudal was as of 8/31/2011
assuming you had DOB = 31-Aug-83 (A1) and compared against 31-Aug-11 (B1)

You get 28 years  do =(B1-A1)/365 and format the cell as number 0 dp

remeber both columns (A1&B1) need to be in date format

alternatively you can also do :

=(DATE(2011,8,31)-A1)/365

8/31/2011 is just a know date for all it is not a column I need to know the age of a person as of 8/31/2011
=(DATE(2011,8,31)-A1)/365  will get you the result you require as long as you format the cell as number 0 dp....

where A1 = the cell where DOB is held for all
=DATEDIF(B2,date(2011,8,31),"y")
for example. Format as Number if you see a strange date.