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.