Function to work out if a date is equal to another

[dpaton05]

I have the date stored in A1 and a formula in another cell

=IF(A1="1/01/*",10,200)

I want the value in the other cell to be 10 if the date is the on new years day for any year and 200 if it is not. What is wrong with my function?

 

[AlphaFrog]

=IF(A1=DATE(YEAR(A1),1,1), 10, 200)

 

[6StringJazzer]

A wildcard does not work in a test for equality. When working with dates, use date functions rather than trying to deal with them as text.

=IF(AND(MONTH(A1)=1, DAY(A1)=1), 10, 200)

 

[dpaton05]

I thought I could just adjust the references but that is not working. The date is part of a table with the header being Date.
The function I had was

=IF([Date]="1/01/*",10,200)

 

[dpaton05]

Actually, I tried it again and got it to work with this function.

=IF([Date]=DATE(YEAR([Date]),1,1), 10, 200)

Thanks guys.

 

[6StringJazzer]

The date is part of a table with the header being Date.

Always better to give the true situation up front.

 

[dpaton05]

ok, thanks.