Census Family Age Chart Tool
Comments
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
$
%
123
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Still loading...
ABCDEFGHIJKLMNOPQRSTUVWXYZAAAB
1
2
Family Age by Census YearCensus Year Increment:10
3
Update: 11/15/2016
4
5
6
Only Enter Values in the Green Cells!Age in Census Year
7
NameBirth YearDeath Year179018001810182018301840185018601870188018901900191019201930194019501960197019801990200020102020
8
John Smith179018860102030405060708090
9
Ann Smith18241902616263646566676
10
Michael1845190951525354555
11
Margaret18461924414243444546474
12
Sabina1847193231323334353637383
13
Kieran185118999192939
14
Helen1851194091929394959697989
15
Katherine186119729192939495969798999109
16
Eamon1930201001020304050607080
17
Eamon Jr.1964999961626364656
18
Henry19759999515253545
19
20
21
22
23
24
Use this sheet to estimate ages based on birth and census years.
25
Cells for census years before birth and after death will automagically turn gray.
If you don't know a death year, just enter 9999 to get all census ages after birth.
26
If you change the first Census year (only one in a green cell) the rest will all calculate in increments Defined by the "Census Year Increment" cell at the top. Normally I'd leave it as 10, but, for example if you want to include ages in years ending in 5 where there was a NY State census, just change the increment to 5.
27
I have protected all of the NON-GREEN Cells so that people can't mistakenly change the formulas, header, and columns. Protected cells may have a crosshatch background when you view the sheet - that makes it hard to see: you can click on the View menu at the top of the page, then de-select "Protected Ranges" to get rid of the crosshatch. Those cells will still be protected, but you can take a nicer screenshot if that is your favorite method of capture.
28
29
YOU CAN DOWNLOAD THIS SHEET to use on your computer in Excel or Open Office by clicking File...Download As...
Alternatively, You can enter your info above and then download it as a PDF to keep as a simple reference page.
30
May the census be with you.
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
Loading...
 
 
 
Census Age Table
Backup Table OLD
Census Age Table Backup DEC2014