Excel experts

[brianlg31]

Do we have any Excel Formula experts on here?

Here's what I wish I could do: Our 4-H age's are based on the age as of Aug 31, 2012. I would like to create a formula that I could type in a birth date and it give me the age as of 8/31/12.

Brian

[dhillis]

doable....send me a pm...ill work on a forula tomorrow afternoon if no one else figures it out by then

[TexasBlazer72]

=INT((DATE(2012,8,31) – DATE(2001,1,1))/365.25)

The first date is your August date. The second date is the kids birthday. The answer will return the age of the child. Let me know if this works.

[brianlg31]

I had already shut it down. So type that into to the insert formula space?

[TexasBlazer72]

Type it directly into the cell

[brianlg31]

Couldn't stand it. . Yes sir that works, cool. Thanks

Brian

[TexasBlazer72]

Couldn't stand it. . Yes sir that works, cool. Thanks

Brian

Glad it worked.