year completion formula

[webmax]

Hi

I have list of Date of Birth in dd-mm-yyyy format i want the formula to find the persons who completed 60 years in the year 2014.

For example the date of birth is 01-12-1954. Between 01st Jan 2014 to 31st Dec 2014 if the persons completed the 60 years the data should come as Yes else No

 

[NARAYANK991]

Hi Shahul ,

Since the 60 years is fixed , and since the year 2014 is fixed , why don't you just check whether the date of birth is between January 1 , 1954 and December 31 , 1954 ?

Narayan

 

[webmax]

Year is fixed.

 

[Xiq]

=YEAR(A1)=1954

 

[Sajan]

perhaps it should be YEAR(A1)<=1954, assuming that if someone is 75 years old, that is still OK.

 

[Sajan]

or perhaps not... re-reading the original post, I think the OP wants to find if someone will turn 60 years old in 2014 and not any earlier!

 

[rakeshsukumar]

The YEAR function can be used to subtract two dates to find the number of years between the dates.
For instance A1 = 01/12/1954 , then use this formula =YEAR("1/1/2014")-YEAR(A1).