Discussion Locked

Date of Birth in Excel 97

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Recently, I was asked what formula(s) (in Excel 97) do you use to calculate the age of a person. Where it will display how many years & months old a person is as of today. One of the cells I filled in was " =Today() " for the current date everytime the spreadsheet is opened. I can get as far as the days old and divide it by 365 for the years, but how do I get the remaining Months. Any help on this will be greatly appreciated.

1 reply

by chainsawz

The age calculation (which includes months) is =(Today's Date-Date of Birth)/365.25. The .25 allows for leap years. So, if cell A1=06/05/01 and B1=11/28/69 then the formula =(A1-B1)/365.25 should provide the result 31.52

This discussion is closed to new replies.