I need to write a formula that calculates a childs age as of 04/30/2006 for
baseball or as of 01/01/06 for softball.

Try

=datedif(BirthDate,BenchmarkDate,"Y")

Regards

Phil Smith

"yancey04" wrote:

I need to write a formula that calculates a childs age as of 04/30/2006 for
baseball or as of 01/01/06 for softball.

To calculate age in years: ([Date] - [Birthdate])/365.25

Assuming you have the child's birthday in B1, "baseball" or "softball" in
C1, then D1 will be:
=IF(C1="baseball",(DATE(2006,04,30)-B1)/365.25,IF(C1="softball",(DATE(2006,01,01)-B1)/365.2,""))

"yancey04" wrote:

I need to write a formula that calculates a childs age as of 04/30/2006 for
baseball or as of 01/01/06 for softball.

Philip: Where is the "DATEDIF" function? I don't see it my list. Is there
an Add-In I'm missing?

"Philip J Smith" wrote:

Try

=datedif(BirthDate,BenchmarkDate,"Y")

Regards

Phil Smith

"yancey04" wrote:

I need to write a formula that calculates a childs age as of 04/30/2006 for
baseball or as of 01/01/06 for softball.

Datedif is apparently from Lotus days and is only documented in 2000 but
supposedly works in the other versions as well. Since I am using 2000, let
me take a look ...
Okay, I see it in help, but not when I use paste function and look under the
all category.

--
Kevin Vaughn


"BekkiM" wrote:

Philip: Where is the "DATEDIF" function? I don't see it my list. Is there
an Add-In I'm missing?

"Philip J Smith" wrote:

Try

=datedif(BirthDate,BenchmarkDate,"Y")

Regards

Phil Smith

"yancey04" wrote:

I need to write a formula that calculates a childs age as of 04/30/2006 for
baseball or as of 01/01/06 for softball.

I should have mentioned in my previous post, I have used it in the past and I
do not have any add-ins installed. Or rather, I don't have any that include
this function. I did create and have installed an add-on that I got out of a
book.
--
Kevin Vaughn


"BekkiM" wrote:

Philip: Where is the "DATEDIF" function? I don't see it my list. Is there
an Add-In I'm missing?

"Philip J Smith" wrote:

Try

=datedif(BirthDate,BenchmarkDate,"Y")

Regards

Phil Smith

"yancey04" wrote:

I need to write a formula that calculates a childs age as of 04/30/2006 for
baseball or as of 01/01/06 for softball.

Thanks! I was able to use the function even though it's not listed--much
easier than my clunky "old-fashioned" method!

"Kevin Vaughn" wrote:

I should have mentioned in my previous post, I have used it in the past and I
do not have any add-ins installed. Or rather, I don't have any that include
this function. I did create and have installed an add-on that I got out of a
book.
--
Kevin Vaughn


"BekkiM" wrote:

Philip: Where is the "DATEDIF" function? I don't see it my list. Is there
an Add-In I'm missing?

"Philip J Smith" wrote:

Try

=datedif(BirthDate,BenchmarkDate,"Y")

Regards

Phil Smith

"yancey04" wrote:

I need to write a formula that calculates a childs age as of 04/30/2006 for
baseball or as of 01/01/06 for softball.

Yes, I tried figuring a person's age using regular formulae and could come
close but couldn't get (my) exact age. Did a google search, found a datedif
formula and it came up with my correct age (though if it had shaved a few
years off, I guess I wouldn't have minded.)
--
Kevin Vaughn


"BekkiM" wrote:

Thanks! I was able to use the function even though it's not listed--much
easier than my clunky "old-fashioned" method!

"Kevin Vaughn" wrote:

I should have mentioned in my previous post, I have used it in the past and I
do not have any add-ins installed. Or rather, I don't have any that include
this function. I did create and have installed an add-on that I got out of a
book.
--
Kevin Vaughn


"BekkiM" wrote:

Philip: Where is the "DATEDIF" function? I don't see it my list. Is there
an Add-In I'm missing?

"Philip J Smith" wrote:

Try

=datedif(BirthDate,BenchmarkDate,"Y")

Regards

Phil Smith

"yancey04" wrote:

I need to write a formula that calculates a childs age as of 04/30/2006 for
baseball or as of 01/01/06 for softball.

The DATEDIF function is in all versions of Excel, but documented
only in Excel 2000. See www.cpearson.com/excel/datedif.htm for
details and documentation.


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


"BekkiM" wrote in message
...
Philip: Where is the "DATEDIF" function? I don't see it my
list. Is there
an Add-In I'm missing?

"Philip J Smith" wrote:

Try

=datedif(BirthDate,BenchmarkDate,"Y")

Regards

Phil Smith

"yancey04" wrote:

I need to write a formula that calculates a childs age as
of 04/30/2006 for
baseball or as of 01/01/06 for softball.