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.
|