Forum Discussion
Solved
If formula
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")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")
2 Replies
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")
