IF statement using dates

[BACcampbell]

I'm trying to create an IF statement that looks at whether a cell populates a specific month to input a different cells data. I need the cell to look at only the beginning of the date as thats the month.
Heres what I currently have IF(LEFT(I10,1)=1,H10,"")

I10 has my date (cell formatted at date), first character on the left should be 1 for january on this particular cell. If it is January, I want this cell to fill in with the data in cell H10, If it is not January I want the cell to stay blank.

It keeps giving me the false data, instead of the true. I've tried numerous little things. (Adding month In front of Left. Deleting the character reference in left.)

 

[Jonmo1]

Welcome to the board.

Try

=IF(MONTH(I10)=1,H10,"")

 

[BACcampbell]

Welcome to the board.

Try

=IF(MONTH(I10)=1,H10,"")

Thank you so much. I guess I overcomplicated it a bit. Worked perfectly.

 

[Jonmo1]

Glad to help, thanks for the feedback.