Hi LadyCat,

It's quite obvious for me that you are trying to test the ability of the
YEAR() function...since you already type the Year "2007" inside the Year
function...

if you type a formula =year(A1) , where A1 contains a date, then you indeed
need to use a year function for some sort of YEAR series presentation...

or by another way is...

if its for presentation, then on A1, you can just format it "YYY" on the
formatcellsnumbercustom and type "yyy" [without the quotes]. In this way
you will not loose your real date value..

regards,
driller

--
*****
birds of the same feather flock together..



"LadyCat" wrote:

I am expecting the answer as 2007 from the function of =YEAR(3/7/2007)