Calculating Age

"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)))
> > >
> > >
> >
> >
> >

It comes up as 5545 instead of 58 yrs,7 mos. (58.58). I tried to change the
formating but it's not coming up correctly. Is there anything else I can do?

"Mangesh Yadav" wrote:

> 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)))
> > > >
> > > >
> > >
> > >
> > >
>
>
>

Could you post your data.
And the formula you are using.

Mangesh



"junepbug" <junepbug@discussions.microsoft.com> wrote in message
news:B9FC79F3-6B25-44EB-B33F-5AC3426F8399@microsoft.com...
> It comes up as 5545 instead of 58 yrs,7 mos. (58.58). I tried to change
the
> formating but it's not coming up correctly. Is there anything else I can
do?
>
> "Mangesh Yadav" wrote:
>
> > 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