Thx Bob,

in fact i would like to have in E1 something like a date e.g : 16.02.2006

and in F1 something like a time e.g : 14:12:27

Al.

Bob Phillips wrote:
This gets the number of years assuming that value is in A1

=DATEDIF(--"1970-01-01",--"1970-01-01"+A1/24/60/60,"Y")

How do you want the answer?