Need to highlight odd and even months for a column that has consecutive dates(01/01/10...01/02/10....to 12/31/10). The formula I need I think is =IsOdd(MOD(MONTH(D6),12)) but in the formula bar I haven't hit on the right = to because it keeps erroring out.
Looking through other threads since yesterday, I haven't found one quite like this. If someone could save me some time and frustration I would appreciate it.
=mod(month(d6), 2) = 1 is an odd month.
Entia non sunt multiplicanda sine necessitate
I tried it and it works except that the last two days of each series do not get formatted even though they are odd numbered months.
Looked back at the formula and the copy made the formula reference D6 instead of D4 so everything is fine now. Thanks for a very quick answer.
Last edited by Excellant; 02-26-2010 at 01:46 PM.
post your workbook
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Attachment for worksheet used
must have posted at same time lol . i take it every thing is now ok?Looked back at the formula and the copy made the formula reference D6 instead of D4 so everything is fine now. Thanks for a very quick answer.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Excellant 
Register To Reply
Bookmarks