Age Calculation

Method-1 : You can calculate a persons age based on their birthday and todays date.
The calculation uses the DATEDIF() function.
The DATEDIF() is not documented in Excel 5, 7 or 97, but it is in 2000.
(Makes you wonder what else Microsoft forgot to tell us!)
Birth date :	1-Jan-60
Years lived :	53	=DATEDIF(C8,TODAY(),"y")
and the months :	1	=DATEDIF(C8,TODAY(),"ym")
and the days :	3	=DATEDIF(C8,TODAY(),"md")
You can put this all together in one calculation, which creates a text version.
Age is 53 Years, 1 Months and 3 Days
="Age is "&DATEDIF(C8,TODAY(),"y")&" Years, "&DATEDIF(C8,TODAY(),"ym")&" Months and "&DATEDIF(C8,TODAY(),"md")&" Days" Method-2 : This method gives you an age which may potentially have decimal places representing the months. If the age is 20.5, the .5 represents 6 months. Birth date : 1-Jan-60 Age is : 53.10  =(TODAY()-C23)/365.25

AutoSum Shortcut Key

Instead of using the AutoSum button from the toolbar,
you can press Alt and = to achieve the same result.
Try it here :
Move to a blank cell in the Total row or column, then press Alt and =.
or
Select a row, column or all cells and then press Alt and =.
		Jan	Feb	Mar	Total
	North	10	50	90
	South	20	60	100
	East	30	70	200
	West	40	80	300
	Total