M
Michael168
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
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