ChatterBank4 mins ago
excel formula (age)..
Answers
No best answer has yet been selected by spaced. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.I had a look at the formula you used weegie-al.....i think its wrong somewhere as it only gives what age the person will be turning this year. Tried it out, and used the two dates of 01/01/1980 and 31/12/1980. Both brought up the same age of 26, when the second one should still be 25.
This is a formula I have seen used before: =INT((TODAY()-A2)/365.25) , as a note to spaced, you might need to change the A2 part to whatever your first cell with a date in it is.
Related Questions
Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.