# Generic Chicks Age Calculator for Weeks or Days

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

1. ### chauqgChillin' With My Peeps

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. ### AirilithChillin' With My Peeps

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. ### HEChickenOverrun 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. ### RidgerunnerChicken 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.