Join dates with custom format and calculate age

BobBridges · #5 04-06-2020, 11:01 AM

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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Default How to automatically Calculate number of days between two dates?	wcngu1	Word	6	10-24-2019 04:20 AM
Calculate time over two dates	Diver	Excel	3	07-22-2017 11:31 PM
Is this possible? - Calculate and Display the date range between 2 specific dates	Premier-UK	Excel	2	08-18-2014 05:43 AM
IF Formula to calculate dates	Sophie1	Excel	2	04-23-2014 07:19 AM
How to change number format of dates	ketanco	Project	1	09-11-2012 02:34 PM