#1
|
|||
|
|||
Date difrence in years and months
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. |
#2
|
||||
|
||||
in cell E2:
Code:
=DATEDIF($B2,E$1,"y")&" yrs "& DATEDIF($B2,E$1,"ym") & " months" |
#3
|
|||
|
|||
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 |