Here is a simple way to calculate age from birthday in Google Spreadsheet (works in Microsoft Excel also)
Imagine that you have a column with date of births in it. Just create another column ‘Age’ and specify the following formula in each of its cell.
E is the date of birth column.
Thanks to this post for showing it.