Excel Ages formatting - Excel

Joined
Mar 5, 2015
Messages
1
Reaction score
0
I want to be able to show children age expectations at a point in time then again at another point and show the differential between the two,

So I need a format that will show 07years 07months (if I type in 0707) and then again type in 0802 and get 08years 02months but then a formula in the end cell that works out the difference between the two ages - i.e. 0007 or 00years 07months.

Hope that makes sense and any help is appreciated !!
 
Back
Top