I am working in Excel 2003, and am new to programming in Excel.
Column A is an imported date (mm/dd/yyyy), Column B is the same date (=A1 formatted as mmm) so that any year will work the same, and column C is text. In column D I want a statement something like this:
=IF(B1="Apr" AND C1="Joe",1,0).
Of course, this isn't working, even though it looks to me like it should. What am I missing? Any help with how to get this working as expected would be greatly appreciated.