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 which contains a column (B) which shows dates of
birth, marriages etc in the format dd/mm/yy. Across row 1 starting at column
c is the year 2010, in column d 2011, column d 2012 etc, what I would like is
a formula to calculate the age of the person concerned or anniversary using
these two criteria. I know it can be done as I have asked this previously,
but unfortunately, I cannot find the post. I will be grateful for any help
that may be given.