Year and Month Question?

  • Thread starter Thread starter Michael168
  • Start date Start date
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
 
because "2003" <> 2003

try
(--TEXT(Full!$A$1000:$A$2000,"yyyy")=A1)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Year and Month Question? 2
Year and Month Question? 1
Excel Vba to change displayed year automatically. 14
Mid-Month function help 3
Lousy routine to get the first available day of the month 2
Add years, months, days to a date 5
Formula to calculate exact months and days between two dates 3
calculating Sick pay entitlement 1

Back
Top