Excel 2003 - Calculating Age in a Range of Cells

Thanks:  0
Likes:  0

# Thread: Excel 2003 - Calculating Age in a Range of Cells

1. ## Excel 2003 - Calculating Age in a Range of Cells

Can anyone tell me if there is an easy way to calculate age from a birthdate in a range of cells. For example, Birthdate is in column B, B2 to B110, and Age is in column C, C2 to C110. I'm using the following formula:
=DATEDIF(B2,TODAY(),"y")
I'm just wondering if there is an easier alternative than inputing and changing this formula for each cell. Thanks!

2. ## Re: Excel 2003 - Calculating Age in a Range of Cells

Hi and welcome to the board,

Is it not possible to copy and paste the formula down? The formula will move respectively all the way down.

Row 2 = =DATEDIF(B2,TODAY(),"y")
Row 3 = =DATEDIF(B3,TODAY(),"y")
Etc....

3. ## Re: Excel 2003 - Calculating Age in a Range of Cells

It only seems to allow me to paste one cell at a time and then I have to go back and change the numbers of the corresponding cells, B2 to B3 and so on. Willing to do this, but it seemed time intensive and I thought there might be a better way.

4. ## Re: Excel 2003 - Calculating Age in a Range of Cells

Welcome to the board.

Since B2 is a relative reference (as opposed to an absolute reference where B\$2 would "lock" the 2 as you copy down or \$B\$2 would lock both the B and the 2 as you copy down or across), you can just copy and paste (or click and drag the bottom right corner of the cell, which changes to a black + sign when you hover the cursor over it) your formula down.

5. ## Re: Excel 2003 - Calculating Age in a Range of Cells

Originally Posted by cquinones
It only seems to allow me to paste one cell at a time and then I have to go back and change the numbers of the corresponding cells, B2 to B3 and so on. Willing to do this, but it seemed time intensive and I thought there might be a better way.
If you select multiple destination cells before you paste, Excel will paste the formula into all of the selected cells...

6. ## Re: Excel 2003 - Calculating Age in a Range of Cells

Thanks, you rock!

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•