# Converting dates to a number

1. ## Converting dates to a number

What formula could I use to convert a date of birth into an age?, e.g.,
06/25/71, 33.

Yes, I know I can just subtract but is there a formula that can do it?

Marguerite

2. ## Re: Converting dates to a number

A very rough way of doing so, if you don't need to count leap years ...

=Int((Today()-A1)/365)&" years old"

Where A1 is the cell which houses your date. Note this MUST be an Excel
recognized date. To check if it's an Excel recognized date, look here:
http://www.vbaexpress.com/kb/getarticle.php?kb_id=323

HTH, and regards,
Zack Barresse

"Kathy" <Kathy@discussions.microsoft.com> wrote in message
news:6187FE5F-C911-45CB-AB0E-9A3654A529B3@microsoft.com...
> What formula could I use to convert a date of birth into an age?, e.g.,
> 06/25/71, 33.
>
> Yes, I know I can just subtract but is there a formula that can do it?
>
> Marguerite

3. ## Re: Converting dates to a number

Marguerite

With early date in A1 and later date or =TODAY() Function in A2

=DATEDIF(A1,A2,"y") & "years," in A3

To get finer resolution enter in A3

=DATEDIF(A1,A2,"y") & "years," & DATEDIF(A1,A2,"ym") & "months,"&
DATEDIF(A1,A2,"md") & "days,"

Note: above is all one line.

Gord Dibben Excel MVP

On Tue, 26 Apr 2005 11:14:11 -0700, "Kathy" <Kathy@discussions.microsoft.com>
wrote:

>What formula could I use to convert a date of birth into an age?, e.g.,
>06/25/71, 33.
>
>Yes, I know I can just subtract but is there a formula that can do it?
>
>Marguerite

4. ## Re: Converting dates to a number

http://www.bygsoftware.com/Excel/functions/datedif.htm

--
Regards
-
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy

"Kathy" <Kathy@discussions.microsoft.com> wrote in message
news:6187FE5F-C911-45CB-AB0E-9A3654A529B3@microsoft.com...
> What formula could I use to convert a date of birth into an age?, e.g.,
> 06/25/71, 33.
>
> Yes, I know I can just subtract but is there a formula that can do it?
>
> Marguerite

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1