Thread
:
When using MONTH function on Blank Cell!! Returns Month=Jan!
View Single Post
#
7
Posted to microsoft.public.excel.misc
Linc
Posts: n/a
When using MONTH function on Blank Cell!! Returns Month=Jan!
=SUM(IF(AND(A2:A7)<"",MONTH(A2:A7)=1),1,0)
This works for me. I don't get the curly brackets in Excel 2002,
though.
Reply With Quote
When using MONTH function on Blank Cell!! Returns Month=Jan!