yes..mr ron!
the problem was in the month names. as u said when i changed the name
of the months from excel format to text..ur formula clicks well!! thks
very much for your prompt clarification..! just for acadamic interest i
am asking the question..why it is not working when the cells are filled
up with months using autofill series?

-via135


--
via135
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=496051