Year and Month Question?

[Michael168]

Hi! Frank Kabel

Thanks for your help. One more question for you.

If I assign say "Aug" in column "B1". How do I quote in the formula s
that it understand that it is equal to 8.

e.g. like this (Month(Full!$A$1000:$A$2000)=B1)

Thanks
Michael

 

[Tom Ogilvy]

You wouldn't. You would put 8 in B1. If you want to put in Aug, then put a
formula in B1 that will translate that to 8

in B1 (Aug in A1)

=IF(A1="","",MONTH(DATEVALUE(A1 & " 1, 2004")))

 

[Frank Kabel]

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