Thread: Calculate age
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Chris Waller Chris Waller is offline
external usenet poster
 
Posts: 43
Default Calculate age

I have an Excel Spreadsheet that contains a column of dates of birth in the
format of dd/mm/yy. Across row 1 I have the current year in column "C"
followed by 2011 in column "D" etc. What I am trying to do is calculate the
ages of all the people using the year of their birth and the years that
appear in row 1. I have posted this previously to this discussion group, but
I do not seem able to find the posting now. Thanks in advance.