If formula

Copper Contributor
Hello! can someone help me solve this issue? In a count.if formula, values ​​are being included that are actually excluded. For example, in the following formula results from June 30 are included when in reality they should be excluded: COUNTIF($B:$B;">06/30/2023")
2 Replies
best response confirmed by Eleonora2450 (Copper Contributor)


Perhaps the values in column B include time as well as the date. If the column is formatted as a date you wouldn't see the time component in the cell.

06/30/2023 corresponds to 12 AM, so 06/30/2023 8:30 AM is larger than 06/30/2023.



@Hans Vogelaar 

Thank you!

I appreciate the assistance!