View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
tiah tiah is offline
external usenet poster
 
Posts: 13
Default Using System Date

ok, i see ! :)

so then make the difference directly :

? round ( ( datevalue("2005-01-01") - DateValue("2004-12-31") )/365.25
,0)


it gives you a number of days, then /365.25 gives you into years
the round makes it no decimals

does it makes sense now ? :)