Calculate horses age as at 1 August

[minigg]

I need a worksheet that will allow me to enter a date (for the hors
show) and then my horses birthday to give me the horses' show age.
In Australia all horses age a year on 1st August so if the horse wa
born on Feb 2nd, 2012 on 1st August 2012 it will be one year old (eve
though technically it is only 5 months old it has to show as
yearling.

Ideas ?

 

[joeu2004]

In Australia all horses age a year on 1st August so if the horse
was born on Feb 2nd, 2012 on 1st August 2012 it will be one year
old

Incredible!

So what would a horse's age be on 1 Aug 2012 if it was born in July 2012: 1
year old?!

And what would a horse's age be on 31 July 2013 if it was born in Sep 2012:
0 years old?!

Looking at http://www.melbournetrackreport.com/how-to-bet-australia.html, I
do see that it says: "Australian horses have their official birthday on
August 1st".

But it does not say __which__ Aug 1st. I can imagine that the date of birth
is the "closest" Aug 1st, with a rule to handle exactly between two firsts
of Aug in leap years.

 

[Ron Rosenfeld]

I need a worksheet that will allow me to enter a date (for the horse
show) and then my horses birthday to give me the horses' show age.
In Australia all horses age a year on 1st August so if the horse was
born on Feb 2nd, 2012 on 1st August 2012 it will be one year old (even
though technically it is only 5 months old it has to show as a
yearling.

Ideas ??

With the DOB in A1, try:

=DATEDIF(DATE(YEAR(A1)-1+(MONTH(A1)>7),8,1),TODAY(),"y")

This assumes that a horse born on 8/1/2012 will not be one year old until 8/1/2013. If that is not the case, and a horse born on 8/1/2012 is immediately one year old, then try:

=DATEDIF(DATE(YEAR(A1)-1+(MONTH(A1-1)>7),8,1),TODAY(),"y")

 

[Ron Rosenfeld]

But it does not say __which__ Aug 1st. I can imagine that the date of birth
is the "closest" Aug 1st, with a rule to handle exactly between two firsts
of Aug in leap years.

All the reading I've done indicates that it is the "next" Aug 1. In other words, a race horse born on 31 Jul 2012 would be 1 year old on 1 Aug 2012 (and compete as a one year old)

In the US the "birthday" is Jan 1.

 

[Ron Rosenfeld]

But it does not say __which__ Aug 1st. I can imagine that the date of birth
is the "closest" Aug 1st, with a rule to handle exactly between two firsts
of Aug in leap years.

For the American Jockey Club -- http://www.jockeyclub.com/pdfs/rules_12_final.pdf

Age of the Thoroughbred: For the purpose of determining
age, the date of birth for all Thoroughbreds is deemed
to be January 1 of the year of foaling.

So, at least in the US, a horse born on Dec 31, 2011 would have been "born" on Jan 1, 2011.

Hmmm, wonder if there's a similar set of rules for the Australian Jockey club:

 

[minigg]

;1609841']On Tue, 26 Feb 2013 22:36:48 +0000, minig

I need a worksheet that will allow me to enter a date (for the horse
show) and then my horses birthday to give me the horses' show age.
In Australia all horses age a year on 1st August so if the horse was
born on Feb 2nd, 2012 on 1st August 2012 it will be one year old (even
though technically it is only 5 months old it has to show as a
yearling.

Ideas ??-

With the DOB in A1, try:

=DATEDIF(DATE(YEAR(A1)-1+(MONTH(A1)>7),8,1),TODAY(),"y")

This assumes that a horse born on 8/1/2012 will not be one year ol
until 8/1/2013. If that is not the case, and a horse born on 8/1/201
is immediately one year old, then try:

=DATEDIF(DATE(YEAR(A1)-1+(MONTH(A1-1)>7),8,1),TODAY(),"y")

Thanks Ron - your solution is perfect !

Yes breeding seasons between Australia (1 Aug) and the USA are differen
(1 Jan) - stands to reason given that Spring is in different month

 

[Ron Rosenfeld]

Thanks Ron - your solution is perfect !

Glad to help. Thanks for the feedback.

Yes breeding seasons between Australia (1 Aug) and the USA are different
(1 Jan) - stands to reason given that Spring is in different months

Well, I would opine that a system that has horses of both one day and 365 days old being treated as if they were the same age defies reason, but then, I'm not a horse breeder or racer
However, since, unlike humans, horses doen't breed year round, the age differences between 1 year olds might not be that great.