Prev: Calculating age
Next: Pivot table format on paste values
From: Chris waller on 21 Mar 2010 10:57
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
From: מיכאל (מיקי) אבידן on 21 Mar 2010 12:08
Take a look at the picture:
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
From: Fred Smith on 21 Mar 2010 12:11
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" <Chriswaller(a)discussions.microsoft.com> wrote in message
news:58BE9EC0-F45E-40A9-A0B4-4EF1C7062EE1(a)microsoft.com...
>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

 | 
Pages: 1
Prev: Calculating age
Next: Pivot table format on paste values