Date difrence in years and months

Pablo2000 · #1 01-03-2024, 03:37 AM

Hi. I need to calculate the age of children against a changing date. For example Given the year [E1]. Desmond would be one year old and zero months. E1 -B6. Hope that makes sence so given the cell E1 how old would all the children be givem there DOBs. I created to columbs only because I thought it might have to be done that way. C = years and D = Months. I am going to have to keep changing E1 from time to time.

TIA

Desmond.

p45cal · #2 01-03-2024, 05:07 AM

in cell E2:

Code:

=DATEDIF($B2,E$1,"y")&" yrs "& DATEDIF($B2,E$1,"ym") & " months"

Copy down (and across if you want).

Pablo2000 · #3 01-03-2024, 08:37 AM

Thanks Great help.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Create report for when a date is 3 years old	Daronovitz	Excel	5	11-01-2022 02:42 PM
Date range mysteriously adding 4 years	akatz85	Excel	7	03-25-2014 12:36 PM
Converting serial number to years, months and days	hannu	Excel	6	02-14-2013 09:21 PM
Adding months to a Date	tsindos	Word	4	10-04-2011 11:20 PM
Using Field Codes to Calculate 5 years from a Date	vandy	Word	1	09-23-2009 11:32 AM