Hi! Frank Kabel,
Yes, it work for month but not for the year.

A1=2003
(TEXT(Full!$A$1000:$A$2000,"yyyy")=A1)

Why ? Any Idea?

Thanks
Michael

Frank Kabel Wrote:
Hi
as Tom said. Don't do this. But as an alternative try:
(TEXT(Full!$A$1000:$A$2000,"MMM")=B1)


--
Regards
Frank Kabel
Frankfurt, Germany



--
Michael16
-----------------------------------------------------------------------
Michael168's Profile: http://www.excelforum.com/member.php...info&userid=60
View this thread: http://www.excelforum.com/showthread.php?threadid=27449