making a "if" function that uses only the month/year values from a date

Hello

I am working on making a 4 column list into a tabel. Essentially, the columns are date, item, debit and kredit. What I want to do is to sort the items into a table where each item is listed along with debit/kredit value, as a function of month/year. In other words, my new table should contain rows that represent the item and columns that represent the month and the year.

I figure I can do this with an if function, something along the lines of =IF(AND(H4=C4;I$2=B4);D4:E4;""), but I cannot work out how to make excel use only the month/year value from my date value. In other words, I have a date value like this:

08-09-2011

but the date itself is irrelevant to me, I want the formula only to look at the month and the year.

Any help would be appreciated.

Thank!

I'm not sure if I understand what you are asking for, but try
- right click --> format cells
- then pick date from the category list, and simply chose the format you like.

Is this what you meant?

I think my problem now is somewhat different, so I'll make a new thread for it. This one is solved, thanks