Determine and build an$$IF$$formula using dates.

Select cell$$G$4$and build a formula to subtract the invoice date from the date paid. The first result is $95$ days.

Copy the formula to cells$$G$5$:G$7$and note the issue when there is no paid date.

Undo the copy task.

Delete the formula in cell$$G$4$and start an$$IF$$formula $[$Logical$$category$].$

For the$$Logical$\_$test$$argument$,$ build the subtraction formula $($from step $7.$a$)$ followed by$>=0.$ The$$logical$\_$test$$is that the result of the subtraction $($the number of days$)$ is greater than or equal to zero, that it is not a negative result.

For the$$Value$\_$if$\_$true$$argument$,$ show the subtraction formula.$$When the result of the subtraction is greater than zero, the subtraction is carried out and the result displays.

For the$$Value$\_$if$\_$false$$argument$,$ type a space. This displays as an empty cell. When the result is a negative number, the cell displays as blank.

Copy the formula to cells$$G$5$:G$33$and preserve the borders.