Question

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 F6, insert a formula without using a function that subtracts the invoice date (cell B6) from the current date (cell B3).

Answer 1

To find the age of an invoice in Excel, subtract the invoice date in cell B6 from the current date in cell B3, and enter the formula =B3-B6 in cell F6.

Step-by-step explanation:

In order to display the age of the invoice in column F on an Excel spreadsheet, Brett needs to calculate the number of days between the current date and the invoice date. To do so without using any Excel functions, he can simply subtract the invoice date in cell B6 from the current date listed in cell B3. Therefore, the formula he should insert in cell F6 would be =B3-B6. This will yield the difference in days, effectively showing the age of the invoice.

Answer 2

To calculate the number of days between the current date and the invoice date without using a function, you can subtract the invoice date from the current date and then apply the number format to display the result as a whole number representing the number of days.

To do this in cell F6:

1. Type the following formula into the cell: =B3-B6
2. Press Enter on your keyboard.
3. Right-click on cell F6 and select "Format Cells" from the dropdown menu.
4. In the "Format Cells" dialog box, select "Number" in the left sidebar.
5. Select "Number" under the "Category" section.
6. Click "OK" to close the dialog box.

The result will be displayed in cell F6 as the number of days between the current date (cell B3) and the invoice date (cell B6).