Calculating Age

If I have a person's birthday, how can I calculate their current age based on
today's date?


Thanks!

You can use the DATEDIF function. E.g.,

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

See www.cpearson.com/excel/datedif.htm for more information about
DATEDIF.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"devinm21" <devinm21@discussions.microsoft.com> wrote in message
news:8D2BEAE4-3E8C-4631-AE2D-0B999CECD47A@microsoft.com...
> If I have a person's birthday, how can I calculate their
> current age based on
> today's date?
>
>
> Thanks!
>

"devinm21" wrote:

> If I have a person's birthday, how can I calculate their current age based on
> today's date?
>
>
> Thanks!
>

"ertug" <ertug@discussions.microsoft.com> wrote in message
news:37A7EE25-5F76-477F-8273-5695FA05A076@microsoft.com...
>
>
> "devinm21" wrote:
>
>> If I have a person's birthday, how can I calculate their current age
>> based on
>> today's date?
>>
>>
>> Thanks!
>>

In whole years:

=YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),1,IF(DAY(NOW())<DAY(A1),1,0)))

There's been a big discussion on this already.

http://excelforum.com/showthread.php...light=bluenose

Mangesh



"Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
news:42a811d0$0$64586$a726171b@news.hal-pc.org...
>
> "ertug" <ertug@discussions.microsoft.com> wrote in message
> news:37A7EE25-5F76-477F-8273-5695FA05A076@microsoft.com...
> >
> >
> > "devinm21" wrote:
> >
> >> If I have a person's birthday, how can I calculate their current age
> >> based on
> >> today's date?
> >>
> >>
> >> Thanks!
> >>
>
> In whole years:
>
>
=YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
1,IF(DAY(NOW())<DAY(A1),1,0)))
>
>

My version of Excel does not have the "DATEIF" function. I was bale to cut
and paste the formula in, and it works fine. However it dispays the results
as Xyears, Xmonths, Xdays. I used to have it displayed as a four digit
(##.##) number, which made finding the average age eay. Any suggestions on
how to get that format back?

"Mangesh Yadav" wrote:

> There's been a big discussion on this already.
>
> http://excelforum.com/showthread.php...light=bluenose
>
> Mangesh
>
>
>
> "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
> news:42a811d0$0$64586$a726171b@news.hal-pc.org...
> >
> > "ertug" <ertug@discussions.microsoft.com> wrote in message
> > news:37A7EE25-5F76-477F-8273-5695FA05A076@microsoft.com...
> > >
> > >
> > > "devinm21" wrote:
> > >
> > >> If I have a person's birthday, how can I calculate their current age
> > >> based on
> > >> today's date?
> > >>
> > >>
> > >> Thanks!
> > >>
> >
> > In whole years:
> >
> >
> =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
> 1,IF(DAY(NOW())<DAY(A1),1,0)))
> >
> >
>
>
>

Then you simply need to subtract the earlier date from the recent, and
format as number.
=A1-B1

Mangesh



"junepbug" <junepbug@discussions.microsoft.com> wrote in message
news:D3AF380A-6B70-408D-8575-214DCE7FD2F7@microsoft.com...
> My version of Excel does not have the "DATEIF" function. I was bale to cut
> and paste the formula in, and it works fine. However it dispays the
results
> as Xyears, Xmonths, Xdays. I used to have it displayed as a four digit
> (##.##) number, which made finding the average age eay. Any suggestions on
> how to get that format back?
>
> "Mangesh Yadav" wrote:
>
> > There's been a big discussion on this already.
> >
> > http://excelforum.com/showthread.php...light=bluenose
> >
> > Mangesh
> >
> >
> >
> > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
> > news:42a811d0$0$64586$a726171b@news.hal-pc.org...
> > >
> > > "ertug" <ertug@discussions.microsoft.com> wrote in message
> > > news:37A7EE25-5F76-477F-8273-5695FA05A076@microsoft.com...
> > > >
> > > >
> > > > "devinm21" wrote:
> > > >
> > > >> If I have a person's birthday, how can I calculate their current
age
> > > >> based on
> > > >> today's date?
> > > >>
> > > >>
> > > >> Thanks!
> > > >>
> > >
> > > In whole years:
> > >
> > >
> >
=YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
> > 1,IF(DAY(NOW())<DAY(A1),1,0)))
> > >
> > >
> >
> >
> >

On Thu, 9 Jun 2005 04:54:09 -0500, "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com>
wrote:

>
>"ertug" <ertug@discussions.microsoft.com> wrote in message
>news:37A7EE25-5F76-477F-8273-5695FA05A076@microsoft.com...
>>
>>
>> "devinm21" wrote:
>>
>>> If I have a person's birthday, how can I calculate their current age
>>> based on
>>> today's date?
>>>
>>>
>>> Thanks!
>>>
>
>In whole years:
>

Somewhat shorter formula:

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


--ron

"devinm21" wrote:

> If I have a person's birthday, how can I calculate their current age based on
> today's date?
>
>
> Thanks!
>

"devinm21" wrote:

> If I have a person's birthday, how can I calculate their current age based on
> today's date?
>
>
> Thanks!
>

"ertug" <ertug@discussions.microsoft.com> wrote in message
news:37A7EE25-5F76-477F-8273-5695FA05A076@microsoft.com...
>
>
> "devinm21" wrote:
>
>> If I have a person's birthday, how can I calculate their current age
>> based on
>> today's date?
>>
>>
>> Thanks!
>>

In whole years:

=YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),1,IF(DAY(NOW())<DAY(A1),1,0)))

There's been a big discussion on this already.

http://excelforum.com/showthread.php...light=bluenose

Mangesh



"Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
news:42a811d0$0$64586$a726171b@news.hal-pc.org...
>
> "ertug" <ertug@discussions.microsoft.com> wrote in message
> news:37A7EE25-5F76-477F-8273-5695FA05A076@microsoft.com...
> >
> >
> > "devinm21" wrote:
> >
> >> If I have a person's birthday, how can I calculate their current age
> >> based on
> >> today's date?
> >>
> >>
> >> Thanks!
> >>
>
> In whole years:
>
>
=YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
1,IF(DAY(NOW())<DAY(A1),1,0)))
>
>

There's been a big discussion on this already.

http://excelforum.com/showthread.php...light=bluenose

Mangesh



"Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
news:42a811d0$0$64586$a726171b@news.hal-pc.org...
>
> "ertug" <ertug@discussions.microsoft.com> wrote in message
> news:37A7EE25-5F76-477F-8273-5695FA05A076@microsoft.com...
> >
> >
> > "devinm21" wrote:
> >
> >> If I have a person's birthday, how can I calculate their current age
> >> based on
> >> today's date?
> >>
> >>
> >> Thanks!
> >>
>
> In whole years:
>
>
=YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
1,IF(DAY(NOW())<DAY(A1),1,0)))
>
>

My version of Excel does not have the "DATEIF" function. I was bale to cut
and paste the formula in, and it works fine. However it dispays the results
as Xyears, Xmonths, Xdays. I used to have it displayed as a four digit
(##.##) number, which made finding the average age eay. Any suggestions on
how to get that format back?

"Mangesh Yadav" wrote:

> There's been a big discussion on this already.
>
> http://excelforum.com/showthread.php...light=bluenose
>
> Mangesh
>
>
>
> "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
> news:42a811d0$0$64586$a726171b@news.hal-pc.org...
> >
> > "ertug" <ertug@discussions.microsoft.com> wrote in message
> > news:37A7EE25-5F76-477F-8273-5695FA05A076@microsoft.com...
> > >
> > >
> > > "devinm21" wrote:
> > >
> > >> If I have a person's birthday, how can I calculate their current age
> > >> based on
> > >> today's date?
> > >>
> > >>
> > >> Thanks!
> > >>
> >
> > In whole years:
> >
> >
> =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
> 1,IF(DAY(NOW())<DAY(A1),1,0)))
> >
> >
>
>
>

My version of Excel does not have the "DATEIF" function. I was bale to cut
and paste the formula in, and it works fine. However it dispays the results
as Xyears, Xmonths, Xdays. I used to have it displayed as a four digit
(##.##) number, which made finding the average age eay. Any suggestions on
how to get that format back?

"Mangesh Yadav" wrote:

> There's been a big discussion on this already.
>
> http://excelforum.com/showthread.php...light=bluenose
>
> Mangesh
>
>
>
> "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
> news:42a811d0$0$64586$a726171b@news.hal-pc.org...
> >
> > "ertug" <ertug@discussions.microsoft.com> wrote in message
> > news:37A7EE25-5F76-477F-8273-5695FA05A076@microsoft.com...
> > >
> > >
> > > "devinm21" wrote:
> > >
> > >> If I have a person's birthday, how can I calculate their current age
> > >> based on
> > >> today's date?
> > >>
> > >>
> > >> Thanks!
> > >>
> >
> > In whole years:
> >
> >
> =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
> 1,IF(DAY(NOW())<DAY(A1),1,0)))
> >
> >
>
>
>

Then you simply need to subtract the earlier date from the recent, and
format as number.
=A1-B1

Mangesh



"junepbug" <junepbug@discussions.microsoft.com> wrote in message
news:D3AF380A-6B70-408D-8575-214DCE7FD2F7@microsoft.com...
> My version of Excel does not have the "DATEIF" function. I was bale to cut
> and paste the formula in, and it works fine. However it dispays the
results
> as Xyears, Xmonths, Xdays. I used to have it displayed as a four digit
> (##.##) number, which made finding the average age eay. Any suggestions on
> how to get that format back?
>
> "Mangesh Yadav" wrote:
>
> > There's been a big discussion on this already.
> >
> > http://excelforum.com/showthread.php...light=bluenose
> >
> > Mangesh
> >
> >
> >
> > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
> > news:42a811d0$0$64586$a726171b@news.hal-pc.org...
> > >
> > > "ertug" <ertug@discussions.microsoft.com> wrote in message
> > > news:37A7EE25-5F76-477F-8273-5695FA05A076@microsoft.com...
> > > >
> > > >
> > > > "devinm21" wrote:
> > > >
> > > >> If I have a person's birthday, how can I calculate their current
age
> > > >> based on
> > > >> today's date?
> > > >>
> > > >>
> > > >> Thanks!
> > > >>
> > >
> > > In whole years:
> > >
> > >
> >
=YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
> > 1,IF(DAY(NOW())<DAY(A1),1,0)))
> > >
> > >
> >
> >
> >

Then you simply need to subtract the earlier date from the recent, and
format as number.
=A1-B1

Mangesh



"junepbug" <junepbug@discussions.microsoft.com> wrote in message
news:D3AF380A-6B70-408D-8575-214DCE7FD2F7@microsoft.com...
> My version of Excel does not have the "DATEIF" function. I was bale to cut
> and paste the formula in, and it works fine. However it dispays the
results
> as Xyears, Xmonths, Xdays. I used to have it displayed as a four digit
> (##.##) number, which made finding the average age eay. Any suggestions on
> how to get that format back?
>
> "Mangesh Yadav" wrote:
>
> > There's been a big discussion on this already.
> >
> > http://excelforum.com/showthread.php...light=bluenose
> >
> > Mangesh
> >
> >
> >
> > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
> > news:42a811d0$0$64586$a726171b@news.hal-pc.org...
> > >
> > > "ertug" <ertug@discussions.microsoft.com> wrote in message
> > > news:37A7EE25-5F76-477F-8273-5695FA05A076@microsoft.com...
> > > >
> > > >
> > > > "devinm21" wrote:
> > > >
> > > >> If I have a person's birthday, how can I calculate their current
age
> > > >> based on
> > > >> today's date?
> > > >>
> > > >>
> > > >> Thanks!
> > > >>
> > >
> > > In whole years:
> > >
> > >
> >
=YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
> > 1,IF(DAY(NOW())<DAY(A1),1,0)))
> > >
> > >
> >
> >
> >

Then you simply need to subtract the earlier date from the recent, and
format as number.
=A1-B1

Mangesh



"junepbug" <junepbug@discussions.microsoft.com> wrote in message
news:D3AF380A-6B70-408D-8575-214DCE7FD2F7@microsoft.com...
> My version of Excel does not have the "DATEIF" function. I was bale to cut
> and paste the formula in, and it works fine. However it dispays the
results
> as Xyears, Xmonths, Xdays. I used to have it displayed as a four digit
> (##.##) number, which made finding the average age eay. Any suggestions on
> how to get that format back?
>
> "Mangesh Yadav" wrote:
>
> > There's been a big discussion on this already.
> >
> > http://excelforum.com/showthread.php...light=bluenose
> >
> > Mangesh
> >
> >
> >
> > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
> > news:42a811d0$0$64586$a726171b@news.hal-pc.org...
> > >
> > > "ertug" <ertug@discussions.microsoft.com> wrote in message
> > > news:37A7EE25-5F76-477F-8273-5695FA05A076@microsoft.com...
> > > >
> > > >
> > > > "devinm21" wrote:
> > > >
> > > >> If I have a person's birthday, how can I calculate their current
age
> > > >> based on
> > > >> today's date?
> > > >>
> > > >>
> > > >> Thanks!
> > > >>
> > >
> > > In whole years:
> > >
> > >
> >
=YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
> > 1,IF(DAY(NOW())<DAY(A1),1,0)))
> > >
> > >
> >
> >
> >

My version of Excel does not have the "DATEIF" function. I was bale to cut
and paste the formula in, and it works fine. However it dispays the results
as Xyears, Xmonths, Xdays. I used to have it displayed as a four digit
(##.##) number, which made finding the average age eay. Any suggestions on
how to get that format back?

"Mangesh Yadav" wrote:

> There's been a big discussion on this already.
>
> http://excelforum.com/showthread.php...light=bluenose
>
> Mangesh
>
>
>
> "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
> news:42a811d0$0$64586$a726171b@news.hal-pc.org...
> >
> > "ertug" <ertug@discussions.microsoft.com> wrote in message
> > news:37A7EE25-5F76-477F-8273-5695FA05A076@microsoft.com...
> > >
> > >
> > > "devinm21" wrote:
> > >
> > >> If I have a person's birthday, how can I calculate their current age
> > >> based on
> > >> today's date?
> > >>
> > >>
> > >> Thanks!
> > >>
> >
> > In whole years:
> >
> >
> =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
> 1,IF(DAY(NOW())<DAY(A1),1,0)))
> >
> >
>
>
>

On Thu, 9 Jun 2005 04:54:09 -0500, "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com>
wrote:

>
>"ertug" <ertug@discussions.microsoft.com> wrote in message
>news:37A7EE25-5F76-477F-8273-5695FA05A076@microsoft.com...
>>
>>
>> "devinm21" wrote:
>>
>>> If I have a person's birthday, how can I calculate their current age
>>> based on
>>> today's date?
>>>
>>>
>>> Thanks!
>>>
>
>In whole years:
>

Somewhat shorter formula:

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


--ron

On Thu, 9 Jun 2005 04:54:09 -0500, "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com>
wrote:

>
>"ertug" <ertug@discussions.microsoft.com> wrote in message
>news:37A7EE25-5F76-477F-8273-5695FA05A076@microsoft.com...
>>
>>
>> "devinm21" wrote:
>>
>>> If I have a person's birthday, how can I calculate their current age
>>> based on
>>> today's date?
>>>
>>>
>>> Thanks!
>>>
>
>In whole years:
>

Somewhat shorter formula:

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


--ron

There's been a big discussion on this already.

http://excelforum.com/showthread.php...light=bluenose

Mangesh



"Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
news:42a811d0$0$64586$a726171b@news.hal-pc.org...
>
> "ertug" <ertug@discussions.microsoft.com> wrote in message
> news:37A7EE25-5F76-477F-8273-5695FA05A076@microsoft.com...
> >
> >
> > "devinm21" wrote:
> >
> >> If I have a person's birthday, how can I calculate their current age
> >> based on
> >> today's date?
> >>
> >>
> >> Thanks!
> >>
>
> In whole years:
>
>
=YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
1,IF(DAY(NOW())<DAY(A1),1,0)))
>
>

On Thu, 9 Jun 2005 04:54:09 -0500, "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com>
wrote:

>
>"ertug" <ertug@discussions.microsoft.com> wrote in message
>news:37A7EE25-5F76-477F-8273-5695FA05A076@microsoft.com...
>>
>>
>> "devinm21" wrote:
>>
>>> If I have a person's birthday, how can I calculate their current age
>>> based on
>>> today's date?
>>>
>>>
>>> Thanks!
>>>
>
>In whole years:
>

Somewhat shorter formula:

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


--ron

"ertug" <ertug@discussions.microsoft.com> wrote in message
news:37A7EE25-5F76-477F-8273-5695FA05A076@microsoft.com...
>
>
> "devinm21" wrote:
>
>> If I have a person's birthday, how can I calculate their current age
>> based on
>> today's date?
>>
>>
>> Thanks!
>>

In whole years:

=YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),1,IF(DAY(NOW())<DAY(A1),1,0)))

"ertug" <ertug@discussions.microsoft.com> wrote in message
news:37A7EE25-5F76-477F-8273-5695FA05A076@microsoft.com...
>
>
> "devinm21" wrote:
>
>> If I have a person's birthday, how can I calculate their current age
>> based on
>> today's date?
>>
>>
>> Thanks!
>>

In whole years:

=YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),1,IF(DAY(NOW())<DAY(A1),1,0)))

"devinm21" wrote:

> If I have a person's birthday, how can I calculate their current age based on
> today's date?
>
>
> Thanks!
>

"devinm21" wrote:

> If I have a person's birthday, how can I calculate their current age based on
> today's date?
>
>
> Thanks!
>

"devinm21" wrote:

> If I have a person's birthday, how can I calculate their current age based on
> today's date?
>
>
> Thanks!
>

"ertug" <ertug@discussions.microsoft.com> wrote in message
news:37A7EE25-5F76-477F-8273-5695FA05A076@microsoft.com...
>
>
> "devinm21" wrote:
>
>> If I have a person's birthday, how can I calculate their current age
>> based on
>> today's date?
>>
>>
>> Thanks!
>>

In whole years:

=YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),1,IF(DAY(NOW())<DAY(A1),1,0)))

There's been a big discussion on this already.

http://excelforum.com/showthread.php...light=bluenose

Mangesh



"Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
news:42a811d0$0$64586$a726171b@news.hal-pc.org...
>
> "ertug" <ertug@discussions.microsoft.com> wrote in message
> news:37A7EE25-5F76-477F-8273-5695FA05A076@microsoft.com...
> >
> >
> > "devinm21" wrote:
> >
> >> If I have a person's birthday, how can I calculate their current age
> >> based on
> >> today's date?
> >>
> >>
> >> Thanks!
> >>
>
> In whole years:
>
>
=YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
1,IF(DAY(NOW())<DAY(A1),1,0)))
>
>

There's been a big discussion on this already.

http://excelforum.com/showthread.php...light=bluenose

Mangesh



"Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
news:42a811d0$0$64586$a726171b@news.hal-pc.org...
>
> "ertug" <ertug@discussions.microsoft.com> wrote in message
> news:37A7EE25-5F76-477F-8273-5695FA05A076@microsoft.com...
> >
> >
> > "devinm21" wrote:
> >
> >> If I have a person's birthday, how can I calculate their current age
> >> based on
> >> today's date?
> >>
> >>
> >> Thanks!
> >>
>
> In whole years:
>
>
=YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
1,IF(DAY(NOW())<DAY(A1),1,0)))
>
>

My version of Excel does not have the "DATEIF" function. I was bale to cut
and paste the formula in, and it works fine. However it dispays the results
as Xyears, Xmonths, Xdays. I used to have it displayed as a four digit
(##.##) number, which made finding the average age eay. Any suggestions on
how to get that format back?

"Mangesh Yadav" wrote:

> There's been a big discussion on this already.
>
> http://excelforum.com/showthread.php...light=bluenose
>
> Mangesh
>
>
>
> "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
> news:42a811d0$0$64586$a726171b@news.hal-pc.org...
> >
> > "ertug" <ertug@discussions.microsoft.com> wrote in message
> > news:37A7EE25-5F76-477F-8273-5695FA05A076@microsoft.com...
> > >
> > >
> > > "devinm21" wrote:
> > >
> > >> If I have a person's birthday, how can I calculate their current age
> > >> based on
> > >> today's date?
> > >>
> > >>
> > >> Thanks!
> > >>
> >
> > In whole years:
> >
> >
> =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
> 1,IF(DAY(NOW())<DAY(A1),1,0)))
> >
> >
>
>
>

Then you simply need to subtract the earlier date from the recent, and
format as number.
=A1-B1

Mangesh



"junepbug" <junepbug@discussions.microsoft.com> wrote in message
news:D3AF380A-6B70-408D-8575-214DCE7FD2F7@microsoft.com...
> My version of Excel does not have the "DATEIF" function. I was bale to cut
> and paste the formula in, and it works fine. However it dispays the
results
> as Xyears, Xmonths, Xdays. I used to have it displayed as a four digit
> (##.##) number, which made finding the average age eay. Any suggestions on
> how to get that format back?
>
> "Mangesh Yadav" wrote:
>
> > There's been a big discussion on this already.
> >
> > http://excelforum.com/showthread.php...light=bluenose
> >
> > Mangesh
> >
> >
> >
> > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
> > news:42a811d0$0$64586$a726171b@news.hal-pc.org...
> > >
> > > "ertug" <ertug@discussions.microsoft.com> wrote in message
> > > news:37A7EE25-5F76-477F-8273-5695FA05A076@microsoft.com...
> > > >
> > > >
> > > > "devinm21" wrote:
> > > >
> > > >> If I have a person's birthday, how can I calculate their current
age
> > > >> based on
> > > >> today's date?
> > > >>
> > > >>
> > > >> Thanks!
> > > >>
> > >
> > > In whole years:
> > >
> > >
> >
=YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
> > 1,IF(DAY(NOW())<DAY(A1),1,0)))
> > >
> > >
> >
> >
> >

Then you simply need to subtract the earlier date from the recent, and
format as number.
=A1-B1

Mangesh



"junepbug" <junepbug@discussions.microsoft.com> wrote in message
news:D3AF380A-6B70-408D-8575-214DCE7FD2F7@microsoft.com...
> My version of Excel does not have the "DATEIF" function. I was bale to cut
> and paste the formula in, and it works fine. However it dispays the
results
> as Xyears, Xmonths, Xdays. I used to have it displayed as a four digit
> (##.##) number, which made finding the average age eay. Any suggestions on
> how to get that format back?
>
> "Mangesh Yadav" wrote:
>
> > There's been a big discussion on this already.
> >
> > http://excelforum.com/showthread.php...light=bluenose
> >
> > Mangesh
> >
> >
> >
> > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
> > news:42a811d0$0$64586$a726171b@news.hal-pc.org...
> > >
> > > "ertug" <ertug@discussions.microsoft.com> wrote in message
> > > news:37A7EE25-5F76-477F-8273-5695FA05A076@microsoft.com...
> > > >
> > > >
> > > > "devinm21" wrote:
> > > >
> > > >> If I have a person's birthday, how can I calculate their current
age
> > > >> based on
> > > >> today's date?
> > > >>
> > > >>
> > > >> Thanks!
> > > >>
> > >
> > > In whole years:
> > >
> > >
> >
=YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
> > 1,IF(DAY(NOW())<DAY(A1),1,0)))
> > >
> > >
> >
> >
> >

My version of Excel does not have the "DATEIF" function. I was bale to cut
and paste the formula in, and it works fine. However it dispays the results
as Xyears, Xmonths, Xdays. I used to have it displayed as a four digit
(##.##) number, which made finding the average age eay. Any suggestions on
how to get that format back?

"Mangesh Yadav" wrote:

> There's been a big discussion on this already.
>
> http://excelforum.com/showthread.php...light=bluenose
>
> Mangesh
>
>
>
> "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
> news:42a811d0$0$64586$a726171b@news.hal-pc.org...
> >
> > "ertug" <ertug@discussions.microsoft.com> wrote in message
> > news:37A7EE25-5F76-477F-8273-5695FA05A076@microsoft.com...
> > >
> > >
> > > "devinm21" wrote:
> > >
> > >> If I have a person's birthday, how can I calculate their current age
> > >> based on
> > >> today's date?
> > >>
> > >>
> > >> Thanks!
> > >>
> >
> > In whole years:
> >
> >
> =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
> 1,IF(DAY(NOW())<DAY(A1),1,0)))
> >
> >
>
>
>

On Thu, 9 Jun 2005 04:54:09 -0500, "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com>
wrote:

>
>"ertug" <ertug@discussions.microsoft.com> wrote in message
>news:37A7EE25-5F76-477F-8273-5695FA05A076@microsoft.com...
>>
>>
>> "devinm21" wrote:
>>
>>> If I have a person's birthday, how can I calculate their current age
>>> based on
>>> today's date?
>>>
>>>
>>> Thanks!
>>>
>
>In whole years:
>

Somewhat shorter formula:

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


--ron

On Thu, 9 Jun 2005 04:54:09 -0500, "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com>
wrote:

>
>"ertug" <ertug@discussions.microsoft.com> wrote in message
>news:37A7EE25-5F76-477F-8273-5695FA05A076@microsoft.com...
>>
>>
>> "devinm21" wrote:
>>
>>> If I have a person's birthday, how can I calculate their current age
>>> based on
>>> today's date?
>>>
>>>
>>> Thanks!
>>>
>
>In whole years:
>

Somewhat shorter formula:

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


--ron

"ertug" <ertug@discussions.microsoft.com> wrote in message
news:37A7EE25-5F76-477F-8273-5695FA05A076@microsoft.com...
>
>
> "devinm21" wrote:
>
>> If I have a person's birthday, how can I calculate their current age
>> based on
>> today's date?
>>
>>
>> Thanks!
>>

In whole years:

=YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),1,IF(DAY(NOW())<DAY(A1),1,0)))

"devinm21" wrote:

> If I have a person's birthday, how can I calculate their current age based on
> today's date?
>
>
> Thanks!
>

"devinm21" wrote:

> If I have a person's birthday, how can I calculate their current age based on
> today's date?
>
>
> Thanks!
>

"ertug" <ertug@discussions.microsoft.com> wrote in message
news:37A7EE25-5F76-477F-8273-5695FA05A076@microsoft.com...
>
>
> "devinm21" wrote:
>
>> If I have a person's birthday, how can I calculate their current age
>> based on
>> today's date?
>>
>>
>> Thanks!
>>

In whole years:

=YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),1,IF(DAY(NOW())<DAY(A1),1,0)))

"ertug" <ertug@discussions.microsoft.com> wrote in message
news:37A7EE25-5F76-477F-8273-5695FA05A076@microsoft.com...
>
>
> "devinm21" wrote:
>
>> If I have a person's birthday, how can I calculate their current age
>> based on
>> today's date?
>>
>>
>> Thanks!
>>

In whole years:

=YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),1,IF(DAY(NOW())<DAY(A1),1,0)))

There's been a big discussion on this already.

http://excelforum.com/showthread.php...light=bluenose

Mangesh



"Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
news:42a811d0$0$64586$a726171b@news.hal-pc.org...
>
> "ertug" <ertug@discussions.microsoft.com> wrote in message
> news:37A7EE25-5F76-477F-8273-5695FA05A076@microsoft.com...
> >
> >
> > "devinm21" wrote:
> >
> >> If I have a person's birthday, how can I calculate their current age
> >> based on
> >> today's date?
> >>
> >>
> >> Thanks!
> >>
>
> In whole years:
>
>
=YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
1,IF(DAY(NOW())<DAY(A1),1,0)))
>
>

There's been a big discussion on this already.

http://excelforum.com/showthread.php...light=bluenose

Mangesh



"Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
news:42a811d0$0$64586$a726171b@news.hal-pc.org...
>
> "ertug" <ertug@discussions.microsoft.com> wrote in message
> news:37A7EE25-5F76-477F-8273-5695FA05A076@microsoft.com...
> >
> >
> > "devinm21" wrote:
> >
> >> If I have a person's birthday, how can I calculate their current age
> >> based on
> >> today's date?
> >>
> >>
> >> Thanks!
> >>
>
> In whole years:
>
>
=YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
1,IF(DAY(NOW())<DAY(A1),1,0)))
>
>

My version of Excel does not have the "DATEIF" function. I was bale to cut
and paste the formula in, and it works fine. However it dispays the results
as Xyears, Xmonths, Xdays. I used to have it displayed as a four digit
(##.##) number, which made finding the average age eay. Any suggestions on
how to get that format back?

"Mangesh Yadav" wrote:

> There's been a big discussion on this already.
>
> http://excelforum.com/showthread.php...light=bluenose
>
> Mangesh
>
>
>
> "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
> news:42a811d0$0$64586$a726171b@news.hal-pc.org...
> >
> > "ertug" <ertug@discussions.microsoft.com> wrote in message
> > news:37A7EE25-5F76-477F-8273-5695FA05A076@microsoft.com...
> > >
> > >
> > > "devinm21" wrote:
> > >
> > >> If I have a person's birthday, how can I calculate their current age
> > >> based on
> > >> today's date?
> > >>
> > >>
> > >> Thanks!
> > >>
> >
> > In whole years:
> >
> >
> =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
> 1,IF(DAY(NOW())<DAY(A1),1,0)))
> >
> >
>
>
>

Then you simply need to subtract the earlier date from the recent, and
format as number.
=A1-B1

Mangesh



"junepbug" <junepbug@discussions.microsoft.com> wrote in message
news:D3AF380A-6B70-408D-8575-214DCE7FD2F7@microsoft.com...
> My version of Excel does not have the "DATEIF" function. I was bale to cut
> and paste the formula in, and it works fine. However it dispays the
results
> as Xyears, Xmonths, Xdays. I used to have it displayed as a four digit
> (##.##) number, which made finding the average age eay. Any suggestions on
> how to get that format back?
>
> "Mangesh Yadav" wrote:
>
> > There's been a big discussion on this already.
> >
> > http://excelforum.com/showthread.php...light=bluenose
> >
> > Mangesh
> >
> >
> >
> > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
> > news:42a811d0$0$64586$a726171b@news.hal-pc.org...
> > >
> > > "ertug" <ertug@discussions.microsoft.com> wrote in message
> > > news:37A7EE25-5F76-477F-8273-5695FA05A076@microsoft.com...
> > > >
> > > >
> > > > "devinm21" wrote:
> > > >
> > > >> If I have a person's birthday, how can I calculate their current
age
> > > >> based on
> > > >> today's date?
> > > >>
> > > >>
> > > >> Thanks!
> > > >>
> > >
> > > In whole years:
> > >
> > >
> >
=YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
> > 1,IF(DAY(NOW())<DAY(A1),1,0)))
> > >
> > >
> >
> >
> >

Then you simply need to subtract the earlier date from the recent, and
format as number.
=A1-B1

Mangesh



"junepbug" <junepbug@discussions.microsoft.com> wrote in message
news:D3AF380A-6B70-408D-8575-214DCE7FD2F7@microsoft.com...
> My version of Excel does not have the "DATEIF" function. I was bale to cut
> and paste the formula in, and it works fine. However it dispays the
results
> as Xyears, Xmonths, Xdays. I used to have it displayed as a four digit
> (##.##) number, which made finding the average age eay. Any suggestions on
> how to get that format back?
>
> "Mangesh Yadav" wrote:
>
> > There's been a big discussion on this already.
> >
> > http://excelforum.com/showthread.php...light=bluenose
> >
> > Mangesh
> >
> >
> >
> > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
> > news:42a811d0$0$64586$a726171b@news.hal-pc.org...
> > >
> > > "ertug" <ertug@discussions.microsoft.com> wrote in message
> > > news:37A7EE25-5F76-477F-8273-5695FA05A076@microsoft.com...
> > > >
> > > >
> > > > "devinm21" wrote:
> > > >
> > > >> If I have a person's birthday, how can I calculate their current
age
> > > >> based on
> > > >> today's date?
> > > >>
> > > >>
> > > >> Thanks!
> > > >>
> > >
> > > In whole years:
> > >
> > >
> >
=YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
> > 1,IF(DAY(NOW())<DAY(A1),1,0)))
> > >
> > >
> >
> >
> >

Then you simply need to subtract the earlier date from the recent, and
format as number.
=A1-B1

Mangesh



"junepbug" <junepbug@discussions.microsoft.com> wrote in message
news:D3AF380A-6B70-408D-8575-214DCE7FD2F7@microsoft.com...
> My version of Excel does not have the "DATEIF" function. I was bale to cut
> and paste the formula in, and it works fine. However it dispays the
results
> as Xyears, Xmonths, Xdays. I used to have it displayed as a four digit
> (##.##) number, which made finding the average age eay. Any suggestions on
> how to get that format back?
>
> "Mangesh Yadav" wrote:
>
> > There's been a big discussion on this already.
> >
> > http://excelforum.com/showthread.php...light=bluenose
> >
> > Mangesh
> >
> >
> >
> > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
> > news:42a811d0$0$64586$a726171b@news.hal-pc.org...
> > >
> > > "ertug" <ertug@discussions.microsoft.com> wrote in message
> > > news:37A7EE25-5F76-477F-8273-5695FA05A076@microsoft.com...
> > > >
> > > >
> > > > "devinm21" wrote:
> > > >
> > > >> If I have a person's birthday, how can I calculate their current
age
> > > >> based on
> > > >> today's date?
> > > >>
> > > >>
> > > >> Thanks!
> > > >>
> > >
> > > In whole years:
> > >
> > >
> >
=YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
> > 1,IF(DAY(NOW())<DAY(A1),1,0)))
> > >
> > >
> >
> >
> >

Then you simply need to subtract the earlier date from the recent, and
format as number.
=A1-B1

Mangesh



"junepbug" <junepbug@discussions.microsoft.com> wrote in message
news:D3AF380A-6B70-408D-8575-214DCE7FD2F7@microsoft.com...
> My version of Excel does not have the "DATEIF" function. I was bale to cut
> and paste the formula in, and it works fine. However it dispays the
results
> as Xyears, Xmonths, Xdays. I used to have it displayed as a four digit
> (##.##) number, which made finding the average age eay. Any suggestions on
> how to get that format back?
>
> "Mangesh Yadav" wrote:
>
> > There's been a big discussion on this already.
> >
> > http://excelforum.com/showthread.php...light=bluenose
> >
> > Mangesh
> >
> >
> >
> > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
> > news:42a811d0$0$64586$a726171b@news.hal-pc.org...
> > >
> > > "ertug" <ertug@discussions.microsoft.com> wrote in message
> > > news:37A7EE25-5F76-477F-8273-5695FA05A076@microsoft.com...
> > > >
> > > >
> > > > "devinm21" wrote:
> > > >
> > > >> If I have a person's birthday, how can I calculate their current
age
> > > >> based on
> > > >> today's date?
> > > >>
> > > >>
> > > >> Thanks!
> > > >>
> > >
> > > In whole years:
> > >
> > >
> >
=YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
> > 1,IF(DAY(NOW())<DAY(A1),1,0)))
> > >
> > >
> >
> >
> >

My version of Excel does not have the "DATEIF" function. I was bale to cut
and paste the formula in, and it works fine. However it dispays the results
as Xyears, Xmonths, Xdays. I used to have it displayed as a four digit
(##.##) number, which made finding the average age eay. Any suggestions on
how to get that format back?

"Mangesh Yadav" wrote:

> There's been a big discussion on this already.
>
> http://excelforum.com/showthread.php...light=bluenose
>
> Mangesh
>
>
>
> "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
> news:42a811d0$0$64586$a726171b@news.hal-pc.org...
> >
> > "ertug" <ertug@discussions.microsoft.com> wrote in message
> > news:37A7EE25-5F76-477F-8273-5695FA05A076@microsoft.com...
> > >
> > >
> > > "devinm21" wrote:
> > >
> > >> If I have a person's birthday, how can I calculate their current age
> > >> based on
> > >> today's date?
> > >>
> > >>
> > >> Thanks!
> > >>
> >
> > In whole years:
> >
> >
> =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
> 1,IF(DAY(NOW())<DAY(A1),1,0)))
> >
> >
>
>
>

My version of Excel does not have the "DATEIF" function. I was bale to cut
and paste the formula in, and it works fine. However it dispays the results
as Xyears, Xmonths, Xdays. I used to have it displayed as a four digit
(##.##) number, which made finding the average age eay. Any suggestions on
how to get that format back?

"Mangesh Yadav" wrote:

> There's been a big discussion on this already.
>
> http://excelforum.com/showthread.php...light=bluenose
>
> Mangesh
>
>
>
> "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
> news:42a811d0$0$64586$a726171b@news.hal-pc.org...
> >
> > "ertug" <ertug@discussions.microsoft.com> wrote in message
> > news:37A7EE25-5F76-477F-8273-5695FA05A076@microsoft.com...
> > >
> > >
> > > "devinm21" wrote:
> > >
> > >> If I have a person's birthday, how can I calculate their current age
> > >> based on
> > >> today's date?
> > >>
> > >>
> > >> Thanks!
> > >>
> >
> > In whole years:
> >
> >
> =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
> 1,IF(DAY(NOW())<DAY(A1),1,0)))
> >
> >
>
>
>

My version of Excel does not have the "DATEIF" function. I was bale to cut
and paste the formula in, and it works fine. However it dispays the results
as Xyears, Xmonths, Xdays. I used to have it displayed as a four digit
(##.##) number, which made finding the average age eay. Any suggestions on
how to get that format back?

"Mangesh Yadav" wrote:

> There's been a big discussion on this already.
>
> http://excelforum.com/showthread.php...light=bluenose
>
> Mangesh
>
>
>
> "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
> news:42a811d0$0$64586$a726171b@news.hal-pc.org...
> >
> > "ertug" <ertug@discussions.microsoft.com> wrote in message
> > news:37A7EE25-5F76-477F-8273-5695FA05A076@microsoft.com...
> > >
> > >
> > > "devinm21" wrote:
> > >
> > >> If I have a person's birthday, how can I calculate their current age
> > >> based on
> > >> today's date?
> > >>
> > >>
> > >> Thanks!
> > >>
> >
> > In whole years:
> >
> >
> =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
> 1,IF(DAY(NOW())<DAY(A1),1,0)))
> >
> >
>
>
>

On Thu, 9 Jun 2005 04:54:09 -0500, "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com>
wrote:

>
>"ertug" <ertug@discussions.microsoft.com> wrote in message
>news:37A7EE25-5F76-477F-8273-5695FA05A076@microsoft.com...
>>
>>
>> "devinm21" wrote:
>>
>>> If I have a person's birthday, how can I calculate their current age
>>> based on
>>> today's date?
>>>
>>>
>>> Thanks!
>>>
>
>In whole years:
>

Somewhat shorter formula:

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


--ron

On Thu, 9 Jun 2005 04:54:09 -0500, "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com>
wrote:

>
>"ertug" <ertug@discussions.microsoft.com> wrote in message
>news:37A7EE25-5F76-477F-8273-5695FA05A076@microsoft.com...
>>
>>
>> "devinm21" wrote:
>>
>>> If I have a person's birthday, how can I calculate their current age
>>> based on
>>> today's date?
>>>
>>>
>>> Thanks!
>>>
>
>In whole years:
>

Somewhat shorter formula:

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


--ron

There's been a big discussion on this already.

http://excelforum.com/showthread.php...light=bluenose

Mangesh



"Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
news:42a811d0$0$64586$a726171b@news.hal-pc.org...
>
> "ertug" <ertug@discussions.microsoft.com> wrote in message
> news:37A7EE25-5F76-477F-8273-5695FA05A076@microsoft.com...
> >
> >
> > "devinm21" wrote:
> >
> >> If I have a person's birthday, how can I calculate their current age
> >> based on
> >> today's date?
> >>
> >>
> >> Thanks!
> >>
>
> In whole years:
>
>
=YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
1,IF(DAY(NOW())<DAY(A1),1,0)))
>
>

On Thu, 9 Jun 2005 04:54:09 -0500, "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com>
wrote:

>
>"ertug" <ertug@discussions.microsoft.com> wrote in message
>news:37A7EE25-5F76-477F-8273-5695FA05A076@microsoft.com...
>>
>>
>> "devinm21" wrote:
>>
>>> If I have a person's birthday, how can I calculate their current age
>>> based on
>>> today's date?
>>>
>>>
>>> Thanks!
>>>
>
>In whole years:
>

Somewhat shorter formula:

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


--ron

There's been a big discussion on this already.

http://excelforum.com/showthread.php...light=bluenose

Mangesh



"Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
news:42a811d0$0$64586$a726171b@news.hal-pc.org...
>
> "ertug" <ertug@discussions.microsoft.com> wrote in message
> news:37A7EE25-5F76-477F-8273-5695FA05A076@microsoft.com...
> >
> >
> > "devinm21" wrote:
> >
> >> If I have a person's birthday, how can I calculate their current age
> >> based on
> >> today's date?
> >>
> >>
> >> Thanks!
> >>
>
> In whole years:
>
>
=YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
1,IF(DAY(NOW())<DAY(A1),1,0)))
>
>

On Thu, 9 Jun 2005 04:54:09 -0500, "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com>
wrote:

>
>"ertug" <ertug@discussions.microsoft.com> wrote in message
>news:37A7EE25-5F76-477F-8273-5695FA05A076@microsoft.com...
>>
>>
>> "devinm21" wrote:
>>
>>> If I have a person's birthday, how can I calculate their current age
>>> based on
>>> today's date?
>>>
>>>
>>> Thanks!
>>>
>
>In whole years:
>

Somewhat shorter formula:

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


--ron

"ertug" <ertug@discussions.microsoft.com> wrote in message
news:37A7EE25-5F76-477F-8273-5695FA05A076@microsoft.com...
>
>
> "devinm21" wrote:
>
>> If I have a person's birthday, how can I calculate their current age
>> based on
>> today's date?
>>
>>
>> Thanks!
>>

In whole years:

=YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),1,IF(DAY(NOW())<DAY(A1),1,0)))

"ertug" <ertug@discussions.microsoft.com> wrote in message
news:37A7EE25-5F76-477F-8273-5695FA05A076@microsoft.com...
>
>
> "devinm21" wrote:
>
>> If I have a person's birthday, how can I calculate their current age
>> based on
>> today's date?
>>
>>
>> Thanks!
>>

In whole years:

=YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),1,IF(DAY(NOW())<DAY(A1),1,0)))

"devinm21" wrote:

> If I have a person's birthday, how can I calculate their current age based on
> today's date?
>
>
> Thanks!
>

"devinm21" wrote:

> If I have a person's birthday, how can I calculate their current age based on
> today's date?
>
>
> Thanks!
>