Constant date in one cell

[dsmith]

Example:
Date 7/1/2013 in cell A1
Then I have Cells B1 through B10 with all different birth dates.
I want to find the years of age using A1 as a constant.

How do I build a formula keeping A1 as a constanct to base all other against?

 

[Claus Busch]

Hi,

Am Tue, 7 May 2013 09:26:22 -0700 (PDT) schrieb
(e-mail address removed)12.ga.us:

Example:
Date 7/1/2013 in cell A1
Then I have Cells B1 through B10 with all different birth dates.
I want to find the years of age using A1 as a constant.

try:
=DATEDIF(B1,$A$1,"y")
and copy down


Regards
Claus Busch