Join dates with custom format and calculate age

BobBridges · #2 04-04-2020, 09:54 AM

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?

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