Constant date in one cell

  • Thread starter Thread starter dsmith
  • Start date Start date
D

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?
 
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.
Click to expand...

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


Regards
Claus Busch
 
Back
Top