PPRuNe Forums - View Single Post - years & months in excel
View Single Post
Old 6th January 2010 | 08:45
  #1 (permalink)  
keyboard flier
20 Anniversary
 
Joined: May 2003
Posts: 172
Likes: 5
From: England
years & months in excel

Hi,
I am trying get an excel sheet to state an age in years and months but cannot do it.
I have a list of dates of birth and in the next column want to have the age in years and months in relation to todays date but all it will say is a the age to 1 decimal place, eg DOB 17/03/66 comes up with 43.8 years not 43 year 9 months.

Can somebody help, please.
keyboard flier is offline  
Reply