Clearly the month value of the date in C2 does not equal the value in G1.
What does =MONTH(C2)=G1 return? Is it TRUE or FALSE
Tell us more about the values in C2 and in G1
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"phocused" wrote in message
...
Don,

that doesnt appear to have made any differenct, it still returns blank
when
i want it to return the column number. Thanks anyway.

Rgds Paul

"Don Guillett" wrote:

Perhaps g1 should be absolute $g$1

--
Don Guillett
SalesAid Software

"phocused" wrote in message
...
Hi,
Can anyone help please.

I have the following straightforward formula in a spreadsheet.
=IF(MONTH(C2)=G1,ROW(),"")
For some reason it doesnt return the row number when the months are the
same. What am I missing?

thanks in advance for the help

Rgds Paul