Calucalates the exact AGE in years, months and days
please follow the below steps to create an excel document which gives the exact age in years, months and days.
1. Create a new excel work book.
2. Copy the below excel fomulae and place it any cell.
3. In the formulae, replace D5 with the cell number in which you will have the date of birth.
4. It will show the age in years, months and days.
="Age is "&DATEDIF(D5,TODAY(),"y")&" Years, "&DATEDIF(D5,TODAY(),"ym")&" Months and "&DATEDIF(D5,TODAY(),"md")&" Days"
123.hp.com/envy5540
ReplyDelete