Calculating Age

[devinm21]

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


Thanks!

[Chip Pearson]

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

[ertug]

"devinm21" wrote:

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

[Vic Sowers]

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

[Mangesh Yadav]

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

[Ron Rosenfeld]

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

[junepbug]

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

[Mangesh Yadav]

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

[junepbug]

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

[Mangesh Yadav]

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

[junepbug]

=DATEDIF(I2,(H2),"y") & " years, " & DATEDIF(I2,(H2),"ym") & "
months, " & DATEDIF(I2,(H2),"md") & " days"

In this case I2 = 11/2/1964 and H2 = 5/2/1996. Formatting cells as a 2
decimal place number fills in "31 years, 6 months, 0 days". Formatting any
other way doesn't return an age.
There was a way to do a "yearif" formula, however since I have had an
upgrade I cannot find that formula. The "yearif" returned 31.50.

Thanks!

"Mangesh Yadav" wrote:

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

[Mangesh Yadav]

Ok. So you are looking for the YEARFRAC function.

=YEARFRAC(I2,H2)

which returns 31.5


Mangesh




"junepbug" <junepbug@discussions.microsoft.com> wrote in message
news:3FCDD341-3146-4B1B-9E2F-4077E8773763@microsoft.com...
> =DATEDIF(I2,(H2),"y") & " years, " & DATEDIF(I2,(H2),"ym") & "
> months, " & DATEDIF(I2,(H2),"md") & " days"
>
> In this case I2 = 11/2/1964 and H2 = 5/2/1996. Formatting cells as a 2
> decimal place number fills in "31 years, 6 months, 0 days". Formatting any
> other way doesn't return an age.
> There was a way to do a "yearif" formula, however since I have had an
> upgrade I cannot find that formula. The "yearif" returned 31.50.
>
> Thanks!
>
> "Mangesh Yadav" wrote:
>
> > 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)))
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > >
> > > >
> > > >
> >
> >
> >

[Mangesh Yadav]

Forgot to mention that you need the Analysis Toolpak to use the YEARFRAC
function.

Mangesh


"junepbug" <junepbug@discussions.microsoft.com> wrote in message
news:3FCDD341-3146-4B1B-9E2F-4077E8773763@microsoft.com...
> =DATEDIF(I2,(H2),"y") & " years, " & DATEDIF(I2,(H2),"ym") & "
> months, " & DATEDIF(I2,(H2),"md") & " days"
>
> In this case I2 = 11/2/1964 and H2 = 5/2/1996. Formatting cells as a 2
> decimal place number fills in "31 years, 6 months, 0 days". Formatting any
> other way doesn't return an age.
> There was a way to do a "yearif" formula, however since I have had an
> upgrade I cannot find that formula. The "yearif" returned 31.50.
>
> Thanks!
>
> "Mangesh Yadav" wrote:
>
> > 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)))
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > >
> > > >
> > > >
> >
> >
> >

[ertug]

"devinm21" wrote:

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

[Vic Sowers]

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

[Mangesh Yadav]

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

[Ron Rosenfeld]

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

[junepbug]

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

[Mangesh Yadav]

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

[junepbug]

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

[Mangesh Yadav]

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

[junepbug]

=DATEDIF(I2,(H2),"y") & " years, " & DATEDIF(I2,(H2),"ym") & "
months, " & DATEDIF(I2,(H2),"md") & " days"

In this case I2 = 11/2/1964 and H2 = 5/2/1996. Formatting cells as a 2
decimal place number fills in "31 years, 6 months, 0 days". Formatting any
other way doesn't return an age.
There was a way to do a "yearif" formula, however since I have had an
upgrade I cannot find that formula. The "yearif" returned 31.50.

Thanks!

"Mangesh Yadav" wrote:

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

[Mangesh Yadav]

Ok. So you are looking for the YEARFRAC function.

=YEARFRAC(I2,H2)

which returns 31.5


Mangesh




"junepbug" <junepbug@discussions.microsoft.com> wrote in message
news:3FCDD341-3146-4B1B-9E2F-4077E8773763@microsoft.com...
> =DATEDIF(I2,(H2),"y") & " years, " & DATEDIF(I2,(H2),"ym") & "
> months, " & DATEDIF(I2,(H2),"md") & " days"
>
> In this case I2 = 11/2/1964 and H2 = 5/2/1996. Formatting cells as a 2
> decimal place number fills in "31 years, 6 months, 0 days". Formatting any
> other way doesn't return an age.
> There was a way to do a "yearif" formula, however since I have had an
> upgrade I cannot find that formula. The "yearif" returned 31.50.
>
> Thanks!
>
> "Mangesh Yadav" wrote:
>
> > 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)))
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > >
> > > >
> > > >
> >
> >
> >

[Mangesh Yadav]

Forgot to mention that you need the Analysis Toolpak to use the YEARFRAC
function.

Mangesh


"junepbug" <junepbug@discussions.microsoft.com> wrote in message
news:3FCDD341-3146-4B1B-9E2F-4077E8773763@microsoft.com...
> =DATEDIF(I2,(H2),"y") & " years, " & DATEDIF(I2,(H2),"ym") & "
> months, " & DATEDIF(I2,(H2),"md") & " days"
>
> In this case I2 = 11/2/1964 and H2 = 5/2/1996. Formatting cells as a 2
> decimal place number fills in "31 years, 6 months, 0 days". Formatting any
> other way doesn't return an age.
> There was a way to do a "yearif" formula, however since I have had an
> upgrade I cannot find that formula. The "yearif" returned 31.50.
>
> Thanks!
>
> "Mangesh Yadav" wrote:
>
> > 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)))
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > >
> > > >
> > > >
> >
> >
> >

[ertug]

"devinm21" wrote:

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

[Vic Sowers]

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

[Mangesh Yadav]

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

[Ron Rosenfeld]

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

[junepbug]

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

[Mangesh Yadav]

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

[junepbug]

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

[Mangesh Yadav]

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

[junepbug]

=DATEDIF(I2,(H2),"y") & " years, " & DATEDIF(I2,(H2),"ym") & "
months, " & DATEDIF(I2,(H2),"md") & " days"

In this case I2 = 11/2/1964 and H2 = 5/2/1996. Formatting cells as a 2
decimal place number fills in "31 years, 6 months, 0 days". Formatting any
other way doesn't return an age.
There was a way to do a "yearif" formula, however since I have had an
upgrade I cannot find that formula. The "yearif" returned 31.50.

Thanks!

"Mangesh Yadav" wrote:

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

[Mangesh Yadav]

Ok. So you are looking for the YEARFRAC function.

=YEARFRAC(I2,H2)

which returns 31.5


Mangesh




"junepbug" <junepbug@discussions.microsoft.com> wrote in message
news:3FCDD341-3146-4B1B-9E2F-4077E8773763@microsoft.com...
> =DATEDIF(I2,(H2),"y") & " years, " & DATEDIF(I2,(H2),"ym") & "
> months, " & DATEDIF(I2,(H2),"md") & " days"
>
> In this case I2 = 11/2/1964 and H2 = 5/2/1996. Formatting cells as a 2
> decimal place number fills in "31 years, 6 months, 0 days". Formatting any
> other way doesn't return an age.
> There was a way to do a "yearif" formula, however since I have had an
> upgrade I cannot find that formula. The "yearif" returned 31.50.
>
> Thanks!
>
> "Mangesh Yadav" wrote:
>
> > 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)))
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > >
> > > >
> > > >
> >
> >
> >

[Mangesh Yadav]

Forgot to mention that you need the Analysis Toolpak to use the YEARFRAC
function.

Mangesh


"junepbug" <junepbug@discussions.microsoft.com> wrote in message
news:3FCDD341-3146-4B1B-9E2F-4077E8773763@microsoft.com...
> =DATEDIF(I2,(H2),"y") & " years, " & DATEDIF(I2,(H2),"ym") & "
> months, " & DATEDIF(I2,(H2),"md") & " days"
>
> In this case I2 = 11/2/1964 and H2 = 5/2/1996. Formatting cells as a 2
> decimal place number fills in "31 years, 6 months, 0 days". Formatting any
> other way doesn't return an age.
> There was a way to do a "yearif" formula, however since I have had an
> upgrade I cannot find that formula. The "yearif" returned 31.50.
>
> Thanks!
>
> "Mangesh Yadav" wrote:
>
> > 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)))
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > >
> > > >
> > > >
> >
> >
> >

[ertug]

"devinm21" wrote:

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

[Vic Sowers]

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

[Mangesh Yadav]

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

[Ron Rosenfeld]

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

[junepbug]

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

[Mangesh Yadav]

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

[junepbug]

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

[Mangesh Yadav]

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

[junepbug]

=DATEDIF(I2,(H2),"y") & " years, " & DATEDIF(I2,(H2),"ym") & "
months, " & DATEDIF(I2,(H2),"md") & " days"

In this case I2 = 11/2/1964 and H2 = 5/2/1996. Formatting cells as a 2
decimal place number fills in "31 years, 6 months, 0 days". Formatting any
other way doesn't return an age.
There was a way to do a "yearif" formula, however since I have had an
upgrade I cannot find that formula. The "yearif" returned 31.50.

Thanks!

"Mangesh Yadav" wrote:

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

[Mangesh Yadav]

Ok. So you are looking for the YEARFRAC function.

=YEARFRAC(I2,H2)

which returns 31.5


Mangesh




"junepbug" <junepbug@discussions.microsoft.com> wrote in message
news:3FCDD341-3146-4B1B-9E2F-4077E8773763@microsoft.com...
> =DATEDIF(I2,(H2),"y") & " years, " & DATEDIF(I2,(H2),"ym") & "
> months, " & DATEDIF(I2,(H2),"md") & " days"
>
> In this case I2 = 11/2/1964 and H2 = 5/2/1996. Formatting cells as a 2
> decimal place number fills in "31 years, 6 months, 0 days". Formatting any
> other way doesn't return an age.
> There was a way to do a "yearif" formula, however since I have had an
> upgrade I cannot find that formula. The "yearif" returned 31.50.
>
> Thanks!
>
> "Mangesh Yadav" wrote:
>
> > 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)))
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > >
> > > >
> > > >
> >
> >
> >

[Mangesh Yadav]

Forgot to mention that you need the Analysis Toolpak to use the YEARFRAC
function.

Mangesh


"junepbug" <junepbug@discussions.microsoft.com> wrote in message
news:3FCDD341-3146-4B1B-9E2F-4077E8773763@microsoft.com...
> =DATEDIF(I2,(H2),"y") & " years, " & DATEDIF(I2,(H2),"ym") & "
> months, " & DATEDIF(I2,(H2),"md") & " days"
>
> In this case I2 = 11/2/1964 and H2 = 5/2/1996. Formatting cells as a 2
> decimal place number fills in "31 years, 6 months, 0 days". Formatting any
> other way doesn't return an age.
> There was a way to do a "yearif" formula, however since I have had an
> upgrade I cannot find that formula. The "yearif" returned 31.50.
>
> Thanks!
>
> "Mangesh Yadav" wrote:
>
> > 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)))
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > >
> > > >
> > > >
> >
> >
> >

[ertug]

"devinm21" wrote:

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

[Vic Sowers]

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

[Mangesh Yadav]

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

[Ron Rosenfeld]

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

[junepbug]

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

[Mangesh Yadav]

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

[junepbug]

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

[Mangesh Yadav]

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

[junepbug]

=DATEDIF(I2,(H2),"y") & " years, " & DATEDIF(I2,(H2),"ym") & "
months, " & DATEDIF(I2,(H2),"md") & " days"

In this case I2 = 11/2/1964 and H2 = 5/2/1996. Formatting cells as a 2
decimal place number fills in "31 years, 6 months, 0 days". Formatting any
other way doesn't return an age.
There was a way to do a "yearif" formula, however since I have had an
upgrade I cannot find that formula. The "yearif" returned 31.50.

Thanks!

"Mangesh Yadav" wrote:

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

[Mangesh Yadav]

Ok. So you are looking for the YEARFRAC function.

=YEARFRAC(I2,H2)

which returns 31.5


Mangesh




"junepbug" <junepbug@discussions.microsoft.com> wrote in message
news:3FCDD341-3146-4B1B-9E2F-4077E8773763@microsoft.com...
> =DATEDIF(I2,(H2),"y") & " years, " & DATEDIF(I2,(H2),"ym") & "
> months, " & DATEDIF(I2,(H2),"md") & " days"
>
> In this case I2 = 11/2/1964 and H2 = 5/2/1996. Formatting cells as a 2
> decimal place number fills in "31 years, 6 months, 0 days". Formatting any
> other way doesn't return an age.
> There was a way to do a "yearif" formula, however since I have had an
> upgrade I cannot find that formula. The "yearif" returned 31.50.
>
> Thanks!
>
> "Mangesh Yadav" wrote:
>
> > 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)))
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > >
> > > >
> > > >
> >
> >
> >

[Mangesh Yadav]

Forgot to mention that you need the Analysis Toolpak to use the YEARFRAC
function.

Mangesh


"junepbug" <junepbug@discussions.microsoft.com> wrote in message
news:3FCDD341-3146-4B1B-9E2F-4077E8773763@microsoft.com...
> =DATEDIF(I2,(H2),"y") & " years, " & DATEDIF(I2,(H2),"ym") & "
> months, " & DATEDIF(I2,(H2),"md") & " days"
>
> In this case I2 = 11/2/1964 and H2 = 5/2/1996. Formatting cells as a 2
> decimal place number fills in "31 years, 6 months, 0 days". Formatting any
> other way doesn't return an age.
> There was a way to do a "yearif" formula, however since I have had an
> upgrade I cannot find that formula. The "yearif" returned 31.50.
>
> Thanks!
>
> "Mangesh Yadav" wrote:
>
> > 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)))
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > >
> > > >
> > > >
> >
> >
> >

[ertug]

"devinm21" wrote:

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

[Vic Sowers]

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

[Mangesh Yadav]

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

[Ron Rosenfeld]

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

[junepbug]

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

[Mangesh Yadav]

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

[junepbug]

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

[Mangesh Yadav]

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

[junepbug]

=DATEDIF(I2,(H2),"y") & " years, " & DATEDIF(I2,(H2),"ym") & "
months, " & DATEDIF(I2,(H2),"md") & " days"

In this case I2 = 11/2/1964 and H2 = 5/2/1996. Formatting cells as a 2
decimal place number fills in "31 years, 6 months, 0 days". Formatting any
other way doesn't return an age.
There was a way to do a "yearif" formula, however since I have had an
upgrade I cannot find that formula. The "yearif" returned 31.50.

Thanks!

"Mangesh Yadav" wrote:

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

[Mangesh Yadav]

Ok. So you are looking for the YEARFRAC function.

=YEARFRAC(I2,H2)

which returns 31.5


Mangesh




"junepbug" <junepbug@discussions.microsoft.com> wrote in message
news:3FCDD341-3146-4B1B-9E2F-4077E8773763@microsoft.com...
> =DATEDIF(I2,(H2),"y") & " years, " & DATEDIF(I2,(H2),"ym") & "
> months, " & DATEDIF(I2,(H2),"md") & " days"
>
> In this case I2 = 11/2/1964 and H2 = 5/2/1996. Formatting cells as a 2
> decimal place number fills in "31 years, 6 months, 0 days". Formatting any
> other way doesn't return an age.
> There was a way to do a "yearif" formula, however since I have had an
> upgrade I cannot find that formula. The "yearif" returned 31.50.
>
> Thanks!
>
> "Mangesh Yadav" wrote:
>
> > 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)))
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > >
> > > >
> > > >
> >
> >
> >

[Mangesh Yadav]

Forgot to mention that you need the Analysis Toolpak to use the YEARFRAC
function.

Mangesh


"junepbug" <junepbug@discussions.microsoft.com> wrote in message
news:3FCDD341-3146-4B1B-9E2F-4077E8773763@microsoft.com...
> =DATEDIF(I2,(H2),"y") & " years, " & DATEDIF(I2,(H2),"ym") & "
> months, " & DATEDIF(I2,(H2),"md") & " days"
>
> In this case I2 = 11/2/1964 and H2 = 5/2/1996. Formatting cells as a 2
> decimal place number fills in "31 years, 6 months, 0 days". Formatting any
> other way doesn't return an age.
> There was a way to do a "yearif" formula, however since I have had an
> upgrade I cannot find that formula. The "yearif" returned 31.50.
>
> Thanks!
>
> "Mangesh Yadav" wrote:
>
> > 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)))
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > >
> > > >
> > > >
> >
> >
> >

[ertug]

"devinm21" wrote:

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

[Vic Sowers]

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

[Mangesh Yadav]

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

[Ron Rosenfeld]

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

[junepbug]

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

[Mangesh Yadav]

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

[junepbug]

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

[Mangesh Yadav]

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

[junepbug]

=DATEDIF(I2,(H2),"y") & " years, " & DATEDIF(I2,(H2),"ym") & "
months, " & DATEDIF(I2,(H2),"md") & " days"

In this case I2 = 11/2/1964 and H2 = 5/2/1996. Formatting cells as a 2
decimal place number fills in "31 years, 6 months, 0 days". Formatting any
other way doesn't return an age.
There was a way to do a "yearif" formula, however since I have had an
upgrade I cannot find that formula. The "yearif" returned 31.50.

Thanks!

"Mangesh Yadav" wrote:

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

[Mangesh Yadav]

Ok. So you are looking for the YEARFRAC function.

=YEARFRAC(I2,H2)

which returns 31.5


Mangesh




"junepbug" <junepbug@discussions.microsoft.com> wrote in message
news:3FCDD341-3146-4B1B-9E2F-4077E8773763@microsoft.com...
> =DATEDIF(I2,(H2),"y") & " years, " & DATEDIF(I2,(H2),"ym") & "
> months, " & DATEDIF(I2,(H2),"md") & " days"
>
> In this case I2 = 11/2/1964 and H2 = 5/2/1996. Formatting cells as a 2
> decimal place number fills in "31 years, 6 months, 0 days". Formatting any
> other way doesn't return an age.
> There was a way to do a "yearif" formula, however since I have had an
> upgrade I cannot find that formula. The "yearif" returned 31.50.
>
> Thanks!
>
> "Mangesh Yadav" wrote:
>
> > 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)))
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > >
> > > >
> > > >
> >
> >
> >

[Mangesh Yadav]

Forgot to mention that you need the Analysis Toolpak to use the YEARFRAC
function.

Mangesh


"junepbug" <junepbug@discussions.microsoft.com> wrote in message
news:3FCDD341-3146-4B1B-9E2F-4077E8773763@microsoft.com...
> =DATEDIF(I2,(H2),"y") & " years, " & DATEDIF(I2,(H2),"ym") & "
> months, " & DATEDIF(I2,(H2),"md") & " days"
>
> In this case I2 = 11/2/1964 and H2 = 5/2/1996. Formatting cells as a 2
> decimal place number fills in "31 years, 6 months, 0 days". Formatting any
> other way doesn't return an age.
> There was a way to do a "yearif" formula, however since I have had an
> upgrade I cannot find that formula. The "yearif" returned 31.50.
>
> Thanks!
>
> "Mangesh Yadav" wrote:
>
> > 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)))
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > >
> > > >
> > > >
> >
> >
> >

[ertug]

"devinm21" wrote:

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

[Vic Sowers]

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

[Mangesh Yadav]

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

[Ron Rosenfeld]

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

[junepbug]

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

[Mangesh Yadav]

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

[junepbug]

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

[Mangesh Yadav]

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

[junepbug]

=DATEDIF(I2,(H2),"y") & " years, " & DATEDIF(I2,(H2),"ym") & "
months, " & DATEDIF(I2,(H2),"md") & " days"

In this case I2 = 11/2/1964 and H2 = 5/2/1996. Formatting cells as a 2
decimal place number fills in "31 years, 6 months, 0 days". Formatting any
other way doesn't return an age.
There was a way to do a "yearif" formula, however since I have had an
upgrade I cannot find that formula. The "yearif" returned 31.50.

Thanks!

"Mangesh Yadav" wrote:

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

[Mangesh Yadav]

Ok. So you are looking for the YEARFRAC function.

=YEARFRAC(I2,H2)

which returns 31.5


Mangesh




"junepbug" <junepbug@discussions.microsoft.com> wrote in message
news:3FCDD341-3146-4B1B-9E2F-4077E8773763@microsoft.com...
> =DATEDIF(I2,(H2),"y") & " years, " & DATEDIF(I2,(H2),"ym") & "
> months, " & DATEDIF(I2,(H2),"md") & " days"
>
> In this case I2 = 11/2/1964 and H2 = 5/2/1996. Formatting cells as a 2
> decimal place number fills in "31 years, 6 months, 0 days". Formatting any
> other way doesn't return an age.
> There was a way to do a "yearif" formula, however since I have had an
> upgrade I cannot find that formula. The "yearif" returned 31.50.
>
> Thanks!
>
> "Mangesh Yadav" wrote:
>
> > 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)))
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > >
> > > >
> > > >
> >
> >
> >

[Mangesh Yadav]

Forgot to mention that you need the Analysis Toolpak to use the YEARFRAC
function.

Mangesh


"junepbug" <junepbug@discussions.microsoft.com> wrote in message
news:3FCDD341-3146-4B1B-9E2F-4077E8773763@microsoft.com...
> =DATEDIF(I2,(H2),"y") & " years, " & DATEDIF(I2,(H2),"ym") & "
> months, " & DATEDIF(I2,(H2),"md") & " days"
>
> In this case I2 = 11/2/1964 and H2 = 5/2/1996. Formatting cells as a 2
> decimal place number fills in "31 years, 6 months, 0 days". Formatting any
> other way doesn't return an age.
> There was a way to do a "yearif" formula, however since I have had an
> upgrade I cannot find that formula. The "yearif" returned 31.50.
>
> Thanks!
>
> "Mangesh Yadav" wrote:
>
> > 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)))
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > >
> > > >
> > > >
> >
> >
> >

[ertug]

"devinm21" wrote:

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

[Vic Sowers]

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

[Mangesh Yadav]

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

[Ron Rosenfeld]

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

[junepbug]

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

[Mangesh Yadav]

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

[junepbug]

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

[Mangesh Yadav]

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

[junepbug]

=DATEDIF(I2,(H2),"y") & " years, " & DATEDIF(I2,(H2),"ym") & "
months, " & DATEDIF(I2,(H2),"md") & " days"

In this case I2 = 11/2/1964 and H2 = 5/2/1996. Formatting cells as a 2
decimal place number fills in "31 years, 6 months, 0 days". Formatting any
other way doesn't return an age.
There was a way to do a "yearif" formula, however since I have had an
upgrade I cannot find that formula. The "yearif" returned 31.50.

Thanks!

"Mangesh Yadav" wrote:

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

[Mangesh Yadav]

Ok. So you are looking for the YEARFRAC function.

=YEARFRAC(I2,H2)

which returns 31.5


Mangesh




"junepbug" <junepbug@discussions.microsoft.com> wrote in message
news:3FCDD341-3146-4B1B-9E2F-4077E8773763@microsoft.com...
> =DATEDIF(I2,(H2),"y") & " years, " & DATEDIF(I2,(H2),"ym") & "
> months, " & DATEDIF(I2,(H2),"md") & " days"
>
> In this case I2 = 11/2/1964 and H2 = 5/2/1996. Formatting cells as a 2
> decimal place number fills in "31 years, 6 months, 0 days". Formatting any
> other way doesn't return an age.
> There was a way to do a "yearif" formula, however since I have had an
> upgrade I cannot find that formula. The "yearif" returned 31.50.
>
> Thanks!
>
> "Mangesh Yadav" wrote:
>
> > 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)))
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > >
> > > >
> > > >
> >
> >
> >

[Mangesh Yadav]

Forgot to mention that you need the Analysis Toolpak to use the YEARFRAC
function.

Mangesh


"junepbug" <junepbug@discussions.microsoft.com> wrote in message
news:3FCDD341-3146-4B1B-9E2F-4077E8773763@microsoft.com...
> =DATEDIF(I2,(H2),"y") & " years, " & DATEDIF(I2,(H2),"ym") & "
> months, " & DATEDIF(I2,(H2),"md") & " days"
>
> In this case I2 = 11/2/1964 and H2 = 5/2/1996. Formatting cells as a 2
> decimal place number fills in "31 years, 6 months, 0 days". Formatting any
> other way doesn't return an age.
> There was a way to do a "yearif" formula, however since I have had an
> upgrade I cannot find that formula. The "yearif" returned 31.50.
>
> Thanks!
>
> "Mangesh Yadav" wrote:
>
> > 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)))
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > >
> > > >
> > > >
> >
> >
> >

[ertug]

"devinm21" wrote:

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

[Vic Sowers]

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

[Mangesh Yadav]

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

[Ron Rosenfeld]

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

[junepbug]

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

[Mangesh Yadav]

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

[junepbug]

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

[Mangesh Yadav]

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

[junepbug]

=DATEDIF(I2,(H2),"y") & " years, " & DATEDIF(I2,(H2),"ym") & "
months, " & DATEDIF(I2,(H2),"md") & " days"

In this case I2 = 11/2/1964 and H2 = 5/2/1996. Formatting cells as a 2
decimal place number fills in "31 years, 6 months, 0 days". Formatting any
other way doesn't return an age.
There was a way to do a "yearif" formula, however since I have had an
upgrade I cannot find that formula. The "yearif" returned 31.50.

Thanks!

"Mangesh Yadav" wrote:

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

[Mangesh Yadav]

Ok. So you are looking for the YEARFRAC function.

=YEARFRAC(I2,H2)

which returns 31.5


Mangesh




"junepbug" <junepbug@discussions.microsoft.com> wrote in message
news:3FCDD341-3146-4B1B-9E2F-4077E8773763@microsoft.com...
> =DATEDIF(I2,(H2),"y") & " years, " & DATEDIF(I2,(H2),"ym") & "
> months, " & DATEDIF(I2,(H2),"md") & " days"
>
> In this case I2 = 11/2/1964 and H2 = 5/2/1996. Formatting cells as a 2
> decimal place number fills in "31 years, 6 months, 0 days". Formatting any
> other way doesn't return an age.
> There was a way to do a "yearif" formula, however since I have had an
> upgrade I cannot find that formula. The "yearif" returned 31.50.
>
> Thanks!
>
> "Mangesh Yadav" wrote:
>
> > 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)))
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > >
> > > >
> > > >
> >
> >
> >

[Mangesh Yadav]

Forgot to mention that you need the Analysis Toolpak to use the YEARFRAC
function.

Mangesh


"junepbug" <junepbug@discussions.microsoft.com> wrote in message
news:3FCDD341-3146-4B1B-9E2F-4077E8773763@microsoft.com...
> =DATEDIF(I2,(H2),"y") & " years, " & DATEDIF(I2,(H2),"ym") & "
> months, " & DATEDIF(I2,(H2),"md") & " days"
>
> In this case I2 = 11/2/1964 and H2 = 5/2/1996. Formatting cells as a 2
> decimal place number fills in "31 years, 6 months, 0 days". Formatting any
> other way doesn't return an age.
> There was a way to do a "yearif" formula, however since I have had an
> upgrade I cannot find that formula. The "yearif" returned 31.50.
>
> Thanks!
>
> "Mangesh Yadav" wrote:
>
> > 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)))
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > >
> > > >
> > > >
> >
> >
> >

[junepbug]

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

[Mangesh Yadav]

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

[junepbug]

=DATEDIF(I2,(H2),"y") & " years, " & DATEDIF(I2,(H2),"ym") & "
months, " & DATEDIF(I2,(H2),"md") & " days"

In this case I2 = 11/2/1964 and H2 = 5/2/1996. Formatting cells as a 2
decimal place number fills in "31 years, 6 months, 0 days". Formatting any
other way doesn't return an age.
There was a way to do a "yearif" formula, however since I have had an
upgrade I cannot find that formula. The "yearif" returned 31.50.

Thanks!

"Mangesh Yadav" wrote:

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

[Mangesh Yadav]

Ok. So you are looking for the YEARFRAC function.

=YEARFRAC(I2,H2)

which returns 31.5


Mangesh




"junepbug" <junepbug@discussions.microsoft.com> wrote in message
news:3FCDD341-3146-4B1B-9E2F-4077E8773763@microsoft.com...
> =DATEDIF(I2,(H2),"y") & " years, " & DATEDIF(I2,(H2),"ym") & "
> months, " & DATEDIF(I2,(H2),"md") & " days"
>
> In this case I2 = 11/2/1964 and H2 = 5/2/1996. Formatting cells as a 2
> decimal place number fills in "31 years, 6 months, 0 days". Formatting any
> other way doesn't return an age.
> There was a way to do a "yearif" formula, however since I have had an
> upgrade I cannot find that formula. The "yearif" returned 31.50.
>
> Thanks!
>
> "Mangesh Yadav" wrote:
>
> > 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)))
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > >
> > > >
> > > >
> >
> >
> >

[Mangesh Yadav]

Forgot to mention that you need the Analysis Toolpak to use the YEARFRAC
function.

Mangesh


"junepbug" <junepbug@discussions.microsoft.com> wrote in message
news:3FCDD341-3146-4B1B-9E2F-4077E8773763@microsoft.com...
> =DATEDIF(I2,(H2),"y") & " years, " & DATEDIF(I2,(H2),"ym") & "
> months, " & DATEDIF(I2,(H2),"md") & " days"
>
> In this case I2 = 11/2/1964 and H2 = 5/2/1996. Formatting cells as a 2
> decimal place number fills in "31 years, 6 months, 0 days". Formatting any
> other way doesn't return an age.
> There was a way to do a "yearif" formula, however since I have had an
> upgrade I cannot find that formula. The "yearif" returned 31.50.
>
> Thanks!
>
> "Mangesh Yadav" wrote:
>
> > 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)))
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > >
> > > >
> > > >
> >
> >
> >