I wouldn't go about it like that. Excel is really good at understanding dates, and I take it you're saying the original date is already in a solid date format; you just need to calculate the age of a given subject, right? So you have a birth date, eg 1954-07-16, or in your case 07/16/1954, and you want to know how old that person is? I'd do it this way: Assuming the birthday is in A1, =TODAY-A1. That gives you the person's age in days; if you want years, you can say =(TODAY-A1)/365.
One problem: You say the birth date is in the format mm/dd/yyyy, but you give as an example "9/9/25", which is not in that format. So which is it?
|