If(And comparing text and a date to the current year

[Darkcloud617]

Hello.

I am having an issue getting a formula to work properly. In cell "A5" I have a date (9/20/2020). In Cell "L5" I have some text. Lastly, on another sheet I have a year that is generated from a formula (2020) in cell "G9". I am trying to write a If(And statement that will match the text to "L5" and the year to "'Sheet1'!G9" and return a 1. If it does not match then stay blank.

I have the below formula and it returns a blank.

Please Login or Register  to view this content.

I am wondering if its because the date in A5 is not just a year but a full date? Any help would be greatly appreciated.

Thank you.

[Estevaoba]

Try
=IF(AND(ISTEXT(L5),YEAR(A5)='Sheet1'!G9),1,"")

Good luck!

[Estevaoba]

Or
=IF(AND(L5="Text",YEAR(A5)=VALUE('Sheet1'!G9)),1,"")

[Darkcloud617]

Thank you. That second formula worked perfectly. I guess I was missing the =Value part of it. Makes sense in retrospect. Thank you again.

[Estevaoba]

You're welcome! Glad to help.
Thank you for the feedback and the rep points added.