Calculating How Old Someone Will Be in a certain year

C

Chris waller

I have a list of dates (birthdays & Anniversaries) in the dd/mm/yyyy format
down a column, with the years in the format yyyy across the first row. I want
a formula that will calculate the age of the person or anniversary by using
just the year part of the date and comparing it with the year across the
first row of the spreadsheet. TIA
 
×

מיכ×ל (מיקי) ×בידן

Take a look at the picture:
http://img509.imageshack.us/img509/346/nonamer.png
Micky
והמשך/×™, × ×, ×œ×§×¨×•× ×ת השורה הב××”:
***********
×× ×ª×’×•×‘×ª×™ עזרה לחץ/×™, × ×, על <כן> בפס ×”×ופקי התחתון!
***********
מיכ×ל ×בידן
מנהל ×¤×•×¨×•× "×ופיס" ב"תפוז"
[Microsoft" Most Valuable Professional [MVP"
 
F

Fred Smith

Do you have a year or a date? A year "in the format yyyy" is actually a
date.

If you have a year, the formula is:
=b$1-year($a2)

If you have a date, it's:
=year(b$1)-year($a2)

Regards,
Fred
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top