r/excel•
Historyhawkeye

Countifs not recognizing a Date Value

unsolved

Hi there as the title says I have the following formula in my excel sheet =COUNTIFS($B10:$B11,$A$2,$C10:$C11,$B$2) I am trying to get excel to recognize and count how many people are checking in on a certain day based on the hotel. This formula continues to throw up either the value error like the photo below or just not count and leave the value as 0.

https://preview.redd.it/4w5ralvvpauf1.png?width=343&format=png&auto=webp&s=8963696b448ca3c824116efadec027926e00aa27

Posted Oct 10, 2025, 2:39 PM UTC

110
Loading comments…