LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 2
Smile Calculate horses age as at 1 August

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 ??
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
is there a formula for "Week of August 4-8' Teacher_Becky New Users to Excel 3 August 2nd 08 12:58 AM
changing August 31, 2007 into 31.08.2007 ziom Excel Worksheet Functions 4 September 17th 07 06:44 AM
date field is held as 38932 how do I export as 3rd August 06 Dave D Excel Programming 2 March 15th 07 12:02 PM
VBA, How to open a file with date like 29 August 2004 Grek[_18_] Excel Programming 2 August 29th 04 08:05 PM
Additional feature to code given on August 6th Metallo[_3_] Excel Programming 3 August 20th 04 10:31 AM


All times are GMT +1. The time now is 12:54 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"