|
|
#1
01-03-2024, 03:37 AM
|
||||
|
||||
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. 
|
|
|
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 |
Windows 11 
Office 2021
Threaded Mode