View Single Post
Old 04-06-2020, 11:01 AM
BobBridges's Avatar
BobBridges BobBridges is offline Windows 7 64bit Office 2010 32bit
Join Date: May 2013
Location: USA
Posts: 676
BobBridges will become famous soon enoughBobBridges will become famous soon enough

Marcia, I haven't looked at Arvi's solution yet, but I think I must have misunderstood your original post. I thought you had a worksheet with a birth date, and you were trying to parse out the year, month and day in order to calculate the victim's age. Now that I read again, I think you're saying your worksheet has the birth date in separate month, day and year columns, and you're trying to reassemble them into a date so you can calculate the age. Is that right?

If so, assuming month is in A2, day in B2 and year in C2, I would try this: The birth date is =DATE(C2,A2,B2). The age in days is =TODAY()-DATE(C2,A2,B2), and if you want it in years (as of course you do) it can be =(TODAY()-DATE(C2,A2,B2))/365.

That's assuming a full four-year birth year. If you have only two years, then you have to make some decision about the year—that is, if the victim is born in "19" is that 2019 or 1919? You'd want to include something like =IF(C2<20,2000+C2,1900+C2).

And if I'm ~still~ not reading carefully, I apologize; try to explain again.
Reply With Quote