If formula

[Eleonora2450]

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 · Accepted solution]

@Eleonora2450 

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.

Try

=COUNTIF($B:$B;">=07/01/2023")

[#3]

@Hans Vogelaar 

Thank you!

I appreciate the assistance!