Read Only $-$ Save a copy to edit.

Save a co

Go to the Client Invoices worksheet. In cell B$3,$ insert a formula using the DATE function to display the current date as $6/1/2024($m$/$d$/$yyyy$)$ so that Brett can use the date in calculations. $[$Mac Hint: The date will display using the formaT.$]$

$2.$ In column F$,$ Brett wants to display the age of the invoice, which is the number of days between the current date and the invoice date. Provide this information as follows:

a$.$ In cell F$6,$ insert a formula without using a function that subtracts the invoice date $($cell B$6)$ from the current date $($cell B$3).$

b$.$ Use an absolute reference to cell $B3$ in the formula.

c$.$ Use the Fill Handle to fill the range F$7$:F$15$ with the formula in cell F$6,$ filling the range without formatting.

$3.$ In column G$,$ Brett wants to calculate the number of days the invoice is overdue. If the age of the invoice is greater than $30$ days, it is overdue. Calculate the days overdue as follows:

a$.$ In cell G$6,$ insert a formula using the IF function that tests whether the age of the invoice $($cell $F6)$ is greater than $30.$

b$.$ If the age of the invoice is greater than $30,$ subtract the due date $($cell E$6)$ from the current date $($cell B$3).$

c$.$ If the age of the invoice is less than or equal to $30,$ display $0$ to show that the invoice is not overdue.

d$.$ Use an absolute reference to cell B$3$ in the formula.