The result displayed is in date format, but the arguments are supplied as integers. We supply the date with the DATE function DATE Function The date function in excel is a date and time function representing the number provided as arguments in a date and time code. Note: The comparison operators in the “criteria” argument must be placed within double quotation marks. Step 3: Since the criterion is on or after 14 th March 2019, it can be represented as “>=14-03-2019.” Type the symbol “>=” in double quotation marks. Step 2: Select the date column (column A) as the range (A2:A13). The COUNTIF function helps count the cells within a particular range based on a criterion. We want to count the number of invoices that are sent on or after 14 th March 2019. The following table shows the date and amount of the invoices sent to the buyer. For example, COUNTIF(A1:A10,”Trump”) will count the number of cells within the range A1:A10 that contain the text “Trump” It is used to count cells that include dates, numbers, or text. Let us use the comparison operator “greater than or equal to” with the COUNTIF COUNTIF The COUNTIF function in Excel counts the number of cells within a range based on pre-defined criteria. Example #3–“Greater Than or Equal to” With the COUNTIF Function Since the values in the cells B5, B11, B12, and B13 are greater than $6500, we get the respective incentive amounts in column C. Step 5: Drag the formula to the remaining cells, as shown in the following image. This implies that the value in cell B2 is less than $6500. In cell C2, the formula returns the output 0. So, we type zero at the end of the formula. Step 4: If the logical test is “false,” the incentives are 0. Step 3: The condition is that if the logical test is “true,” we calculate the incentives as B2*10%.