Hi, I have used lookup to return dates that I then want to use an IF function
to see whether the data matches. I have taken the data from two sources, one
gives me just the month, and the other provides the date in dd/mm/yyyy
format. What I want to know is when the month is the same. I have formatted
the dd/mm/yyyy cell to show the month, however, the underlying data is still
dd/mm/yyyy so when I use the if function I get an incorrect result. Is there
a way I can do this.

e.g.
Column A Column B
October October, but data is 30/10/2004
September June but data is 30/06/2004

In column C, I want to return whether the months are the same or not. Thanks