Enclose the date quotes:

=YEAR("3/7/2007")

Otherwise you are saying Year( 3 divided by 7 divided by 2007)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"LadyCat" wrote in message
...
I am expecting the answer as 2007 from the function of =YEAR(3/7/2007)