CountIFS will only return 0

[Rydsmith]

I am about to throw this computer through a wall. I cannot get this formula to work. It's a simple COUNTIFS if a certain number appears in a context between two dates.

A120 = 07/01/21
A121 = 07/31/21
Transfer is the column with the phone numbers
Call_Date is the column of the date of the phone call

=COUNTIFS(Transfer,"*8665812501*",Call_Date,">="&$A$120,Call_Date,"<="&$A$121)

This worked perfectly until about a month or so ago and now it only spits out 0.

I checked and the named column of Call_Date is correctly formatted as a date and the Transfer column hasn't changed of the data I'm getting in. If I do the two seapately (i.e. a simple COUNTIF based on the Numebr or a COUNTIFS based on the Call_Date they work perfectly but together they are only producing 0 as a result. I cannot figure out for the life of me why this happening. Worked perfectly fine only about a month ago.

 

[Rydsmith]

Figure it out, was the use of the asteriks. Prior to last month the phone number was inside of a string "Company Department (8675309)" and I needed them in order to pull out the number of the string but then it was just changed to the phone number with no identifier.