Constant date in one cell

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?
 
C

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top