unions, intersections or array constants
If AK2 is a number...
....from 1 to 31...
--
Biff
Microsoft Excel MVP
"T. Valko" wrote in message
...
=ISODD(MONTH(DATEVALUE("1-"&$AK$2&"-2000")))
If AK2 is a number the format is applied based on the month number of the
date serial number.
--
Biff
Microsoft Excel MVP
"T. Valko" wrote in message
...
=ISODD(MONTH(DATEVALUE("1-"&$AK$2&"-2000")))
ISODD uses the ATP. Excel will complain. I'd use MOD instead. But, I'd
like to know if these are formula results or user entered. I went under
the assumption they were formula results as they were presented in
uppercase.
--
Biff
Microsoft Excel MVP
"Glenn" wrote in message
...
Rick Rothstein wrote:
Good point! Maybe these formulas instead...
=AND($AK$2<"",NOT(ISNUMBER(FIND("*",$AK$2))),SEAR CH("*"&$AK$2&"*","*JAN*MAR*MAY*JUL*SEP*NOV*"))
=AND($AK$2<"",NOT(ISNUMBER(FIND("*",$AK$2))),SEAR CH("*"&$AK$2&"*","*FEB*APR*JUN*AUG*OCT*DEC*"))
Why not something like this:
=ISODD(MONTH(DATEVALUE("1-"&$AK$2&"-2000")))
|