Posted: 8/10/2006 4:58:03 PM EDT
|
I need a formula to calculate age. Say, a field has a date of birth (mo./day/year) and you want to know how old they are without manually figuring it out from the DOB. We would put the "age" in a new field just for that. Can you help me with the formula?? Much thanks. Colt |
|
Lets say you have your birth dates in column A.... In column B across from the first birthdate, enter the following formula: =TODAY()-A1 Now select the entire column B, click on 'Format', 'Cells', and select 'number' In column C enter the following formula: =B1/365 Now in Column C you will see the exact age based on the birthdate compared to Todays date. |
|
The previous poster is right, but missing one point. Make sure you divide by 365 because subtracting the two years will only give you the days. Dividing by 365 gives you age in years. Try this formula on for size "=(Today()-A1)/365" assuming that cell A1 is the cell you have the birthday in. If it gives you some weird output, just go to "Format" in the tool bar, select "Cells" and select "Number." This should give you the output you want. |
|
Below is an excellent resource for Excel questions in general. The search function for the Excel board works very well, and people are generally very helpful and courteous: www.mrexcel.com/board2/ |