Hi there,

How can I create a formula that will determine how old someone is (in years)
if they enter their date of birth in another cell?

ex.

B2 is DOB = 01-01-1970
B3 needs is show age (36)

Thanks,
Matt

In B3 use the formula

=DATEDIF(B2,TODAY(),"y")

"mpenkala" wrote:

Hi there,

How can I create a formula that will determine how old someone is (in years)
if they enter their date of birth in another cell?

ex.

B2 is DOB = 01-01-1970
B3 needs is show age (36)

Thanks,
Matt

Use the 'undocumented' DATEDIF function

=DATEDIF(B2,NOW(),"y")

check www.cpearson.com/excel/datetime.htm for detail

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"mpenkala" wrote in message
...
Hi there,

How can I create a formula that will determine how old someone is (in
years)
if they enter their date of birth in another cell?

ex.

B2 is DOB = 01-01-1970
B3 needs is show age (36)

Thanks,
Matt

Hi,

This function is not working. I typed in the following function into cell D2

=DATEDIF(B2,NOW(),"y")

B2 contains the date 8/25/1979 (August 25, 1979)

and it returns the following:

1/27/1900 0:00

I've also tried using TODAY instead of NOW, but get the same result.

Any other suggestions?

Thanks,
Matt


"Nick Hodge" wrote:

Use the 'undocumented' DATEDIF function

=DATEDIF(B2,NOW(),"y")

check www.cpearson.com/excel/datetime.htm for detail

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"mpenkala" wrote in message
...
Hi there,

How can I create a formula that will determine how old someone is (in
years)
if they enter their date of birth in another cell?

ex.

B2 is DOB = 01-01-1970
B3 needs is show age (36)

Thanks,
Matt

Hello mpenkala,

the formula is working OK but you need to format the cell that contains the
formula with "general" format rather than the date format you currently have

"mpenkala" wrote:

Hi,

This function is not working. I typed in the following function into cell D2

=DATEDIF(B2,NOW(),"y")

B2 contains the date 8/25/1979 (August 25, 1979)

and it returns the following:

1/27/1900 0:00

I've also tried using TODAY instead of NOW, but get the same result.

Any other suggestions?

Thanks,
Matt


"Nick Hodge" wrote:

Use the 'undocumented' DATEDIF function

=DATEDIF(B2,NOW(),"y")

check www.cpearson.com/excel/datetime.htm for detail

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"mpenkala" wrote in message
...
Hi there,

How can I create a formula that will determine how old someone is (in
years)
if they enter their date of birth in another cell?

ex.

B2 is DOB = 01-01-1970
B3 needs is show age (36)

Thanks,
Matt

daddylonglegs,

thanks a bunch. That solved the problem.

Matt


"daddylonglegs" wrote:

Hello mpenkala,

the formula is working OK but you need to format the cell that contains the
formula with "general" format rather than the date format you currently have

"mpenkala" wrote:

Hi,

This function is not working. I typed in the following function into cell D2

=DATEDIF(B2,NOW(),"y")

B2 contains the date 8/25/1979 (August 25, 1979)

and it returns the following:

1/27/1900 0:00

I've also tried using TODAY instead of NOW, but get the same result.

Any other suggestions?

Thanks,
Matt


"Nick Hodge" wrote:

Use the 'undocumented' DATEDIF function

=DATEDIF(B2,NOW(),"y")

check www.cpearson.com/excel/datetime.htm for detail

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"mpenkala" wrote in message
...
Hi there,

How can I create a formula that will determine how old someone is (in
years)
if they enter their date of birth in another cell?

ex.

B2 is DOB = 01-01-1970
B3 needs is show age (36)

Thanks,
Matt