How do I get the day name in Excel to work in a formula

I converted the date using custom and the type is dddd.That worked fine, but when I reference the cell that the converted date is in using the countif function it won't calculate. I thought there was a problem with my formula but when I manually enter the day my formula worked. How can I fix this problem?

Recent Questions...