said: Could you please tell me a way to return the number of years from a given date Eg 29-02-1980 wourld return 18 Lotus has a function (@Datedif), but I cant't find one to do the same thing in Excel

D*nny said: Use this formula =TRUNC((x-y)/364.25,0) where x is the latest date (d/m/yy) and y is the earlier date. (in separate cells of course) If you want you can replace x with now() which will be the current date. However it will change daily. (insignificant) If you want to record the age up to when say a person has died use this formula IF(c="",TRUNC((NOW()-y)/364.25,0),TRUNC((c-x)/364.25,0)) where c is the date of death (in another cell) Sorry this is long winded but I couldn't get an answer to that same question so I worked from ground up.

st*140103 said: Hello Danny, I see that you are bored, because you posted in a post, which is 6 years old! These will Not make the Mod’s happy.