View Single Post
 
Old 04-04-2020, 09:54 AM
BobBridges's Avatar
BobBridges BobBridges is offline Windows 7 64bit Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

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?
Reply With Quote