Generic Chicks Age Calculator for Weeks or Days

Discussion in 'Raising Baby Chicks' started by chauqg, Dec 11, 2009.

  1. chauqg

    chauqg Chillin' With My Peeps

    131
    1
    101
    Jun 13, 2009
    This is a simple spread sheet created with google docs that will calculate the age in days/weeks of your chicks. Enter the date of hatching in the mm/dd/yyyy format or double click on the @ field to get a calendar to click on. Hope this simplifies the process for aging your chicks... It did for me... Hatcheries have a specific number of weeks when you MUST report roos to be able to get credit - this calculator will do it for you.

    Cheerz

    http://tinyurl.com/yco9p5m
     
  2. Airilith

    Airilith Chillin' With My Peeps

    478
    1
    121
    Sep 28, 2009
    Eastern Shore, VA
    Very nice.

    And for anyone who uses excel here's a formula that produces a similar result:

    =IF(B4="","",VALUE(INT(DATEDIF(B4,TODAY(),"d")/7)&"."&(MOD(DATEDIF(B4,TODAY(),"d"),7))))

    B4 = hatch date (just change that if you have hatch date in another cell)

    This will calculate their current age, as of today's date, and return it in this fashion. 4.4weeks ... meaning 4 weeks and 4 days. It has come in handy to have an exact date on my chickies.
     
  3. HEChicken

    HEChicken Overrun With Chickens

    7,544
    172
    316
    Aug 12, 2009
    BuCo, KS
    My Coop
    Thanks - this is a useful formula to add to the spreadsheet I was also keeping on them....
     
    Last edited: Dec 12, 2009
  4. Ridgerunner

    Ridgerunner Chicken Obsessed

    20,113
    3,318
    496
    Feb 2, 2009
    Northwest Arkansas
    Quote:To make it easier for others to set this up, I used this format for hatch date in cell B4 - month/date/year, as in mm/dd/yyyy. Other formats might work but once I found one that did work, I quit looking. As mentioned, just change B4 to the cell you have hatch date. Also the output is in weeks.
     

BackYard Chickens is proudly sponsored by