Calculate age
If you use Jan-20xx for the value in row 1, you can then subtract the date
in column A from the value in Row 1 Column B, and divide by 365 this will
give you their age.
"Chris waller" wrote:
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.
|