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 pictu
http://img509.imageshack.us/img509/346/nonamer.png
Micky
והמשך/×™, ×*×�, לקרו×� ×�ת השורה הב×�×”:
***********
×�×� תגובתי עזרה לחץ/×™, ×*×�, על <כן בפס ×”×�ופקי התחתון!
***********
מיכ�ל �בידן
מ×*הל פורו×� "×�ופיס" ב"תפוז"
[Microsoft" Most Valuable Professional [MVP"


"Chris waller" wrote:

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

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

"Chris waller" wrote in message
...
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