Census Family Age Chart Tool

	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB
1
2	Family Age by Census Year				Census Year Increment:				10
3	Update: 11/15/2016
4
5
6	Only Enter Values in the Green Cells!			Age in Census Year
7	Name	Birth Year	Death Year	1841	1851	1861	1871	1881	1891	1901	1911	1921	1931	1941	1951	1961	1971	1981	1991	2001	2011	2021	2031	2041	2051	2061	2071
8	John Smith	1875	1906					6	16	26
9	Ann Smith	1826	1902	15	25	35	45	55	65	75
10	Michael	1845	1909		6	16	26	36	46	56
11	Margaret	1846	1924		5	15	25	35	45	55	65	75
12	Sabina	1847	1932		4	14	24	34	44	54	64	74	84
13	Kieran	1851	1899		0	10	20	30	40
14	Helen	1899	1940							2	12	22	32
15	Katherine	1901	1958							0	10	20	30	40	50
16	Weird Uncle Billy	1784	1892	57	67	77	87	97	107
17
18
19
20
21
22
23
24
25	Use this sheet to estimate ages based on birth and census years.
26	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.
27	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.
28	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.
29
30	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.
31	May the census be with you.
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51