---------------------------------------------------------------

I am developing a spread sheet that needs to display the data /
contents of one cell in another cell only if the following conditions
are true / have been met.

Example:

Cell A1 contains a purchase date (i.e. 11-12-2003)

Cell B1 contains a purchase price (i.e. $40.00)

In addition to the above columns (purchase date & purchase price) I
have 12 columns labeled Jan 03 - Dec 03 for the months of the year.

I want to create an "IF()" statement that will disply the purchase
price in the correct month column and a "0" in the rest of the columns
based on the following conditions:

Condition A: IF(MONTH(A1=X))

and

Condition B: IF(YEAR(A1=Y))

I have tried the following functions, but they always display the
purchase price no matter what date has been entered.

1.) =IF(AND(MONTH(A1=X),YEAR(A1=Y)),B1,0)
2.) =IF(MONTH(A1=X),B1,IF(YEAR(A1=Y),B1,0))

Any assistance provided will be greatly appreciated, and thank you in
advance to all that may offer assistance.

---------------------------------------------------------------