software

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,quot;Yquot;)

Regards

Phil Smith

quot;yancey04quot; wrote:

gt; I need to write a formula that calculates a childs age as of 04/30/2006 for
gt; 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, quot;baseballquot; or quot;softballquot; in
C1, then D1 will be:
=IF(C1=quot;baseballquot;,(DATE(2006,04,30)-B1)/365.25,IF(C1=quot;softballquot;,(DATE(2006,01,01)-B1)/365.2,quot;quot;))

quot;yancey04quot; wrote:

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

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

quot;Philip J Smithquot; wrote:

gt; Try
gt;
gt; =datedif(BirthDate,BenchmarkDate,quot;Yquot;)
gt;
gt; Regards
gt;
gt; Phil Smith
gt;
gt; quot;yancey04quot; wrote:
gt;
gt; gt; I need to write a formula that calculates a childs age as of 04/30/2006 for
gt; gt; 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 Vaughnquot;BekkiMquot; wrote:

gt; Philip: Where is the quot;DATEDIFquot; function? I don't see it my list. Is there
gt; an Add-In I'm missing?
gt;
gt; quot;Philip J Smithquot; wrote:
gt;
gt; gt; Try
gt; gt;
gt; gt; =datedif(BirthDate,BenchmarkDate,quot;Yquot;)
gt; gt;
gt; gt; Regards
gt; gt;
gt; gt; Phil Smith
gt; gt;
gt; gt; quot;yancey04quot; wrote:
gt; gt;
gt; gt; gt; I need to write a formula that calculates a childs age as of 04/30/2006 for
gt; gt; gt; 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 Vaughnquot;BekkiMquot; wrote:

gt; Philip: Where is the quot;DATEDIFquot; function? I don't see it my list. Is there
gt; an Add-In I'm missing?
gt;
gt; quot;Philip J Smithquot; wrote:
gt;
gt; gt; Try
gt; gt;
gt; gt; =datedif(BirthDate,BenchmarkDate,quot;Yquot;)
gt; gt;
gt; gt; Regards
gt; gt;
gt; gt; Phil Smith
gt; gt;
gt; gt; quot;yancey04quot; wrote:
gt; gt;
gt; gt; gt; I need to write a formula that calculates a childs age as of 04/30/2006 for
gt; gt; gt; 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 quot;old-fashionedquot; method!

quot;Kevin Vaughnquot; wrote:

gt; I should have mentioned in my previous post, I have used it in the past and I
gt; do not have any add-ins installed. Or rather, I don't have any that include
gt; this function. I did create and have installed an add-on that I got out of a
gt; book.
gt; --
gt; Kevin Vaughn
gt;
gt;
gt; quot;BekkiMquot; wrote:
gt;
gt; gt; Philip: Where is the quot;DATEDIFquot; function? I don't see it my list. Is there
gt; gt; an Add-In I'm missing?
gt; gt;
gt; gt; quot;Philip J Smithquot; wrote:
gt; gt;
gt; gt; gt; Try
gt; gt; gt;
gt; gt; gt; =datedif(BirthDate,BenchmarkDate,quot;Yquot;)
gt; gt; gt;
gt; gt; gt; Regards
gt; gt; gt;
gt; gt; gt; Phil Smith
gt; gt; gt;
gt; gt; gt; quot;yancey04quot; wrote:
gt; gt; gt;
gt; gt; gt; gt; I need to write a formula that calculates a childs age as of 04/30/2006 for
gt; gt; gt; gt; 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 Vaughnquot;BekkiMquot; wrote:

gt; Thanks! I was able to use the function even though it's not listed--much
gt; easier than my clunky quot;old-fashionedquot; method!
gt;
gt; quot;Kevin Vaughnquot; wrote:
gt;
gt; gt; I should have mentioned in my previous post, I have used it in the past and I
gt; gt; do not have any add-ins installed. Or rather, I don't have any that include
gt; gt; this function. I did create and have installed an add-on that I got out of a
gt; gt; book.
gt; gt; --
gt; gt; Kevin Vaughn
gt; gt;
gt; gt;
gt; gt; quot;BekkiMquot; wrote:
gt; gt;
gt; gt; gt; Philip: Where is the quot;DATEDIFquot; function? I don't see it my list. Is there
gt; gt; gt; an Add-In I'm missing?
gt; gt; gt;
gt; gt; gt; quot;Philip J Smithquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Try
gt; gt; gt; gt;
gt; gt; gt; gt; =datedif(BirthDate,BenchmarkDate,quot;Yquot;)
gt; gt; gt; gt;
gt; gt; gt; gt; Regards
gt; gt; gt; gt;
gt; gt; gt; gt; Phil Smith
gt; gt; gt; gt;
gt; gt; gt; gt; quot;yancey04quot; wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; gt; I need to write a formula that calculates a childs age as of 04/30/2006 for
gt; gt; gt; gt; gt; 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.comquot;BekkiMquot; gt; wrote in message
...
gt; Philip: Where is the quot;DATEDIFquot; function? I don't see it my
gt; list. Is there
gt; an Add-In I'm missing?
gt;
gt; quot;Philip J Smithquot; wrote:
gt;
gt;gt; Try
gt;gt;
gt;gt; =datedif(BirthDate,BenchmarkDate,quot;Yquot;)
gt;gt;
gt;gt; Regards
gt;gt;
gt;gt; Phil Smith
gt;gt;
gt;gt; quot;yancey04quot; wrote:
gt;gt;
gt;gt; gt; I need to write a formula that calculates a childs age as
gt;gt; gt; of 04/30/2006 for
gt;gt; gt; baseball or as of 01/01/06 for softball.