1.Create a dataset like below for the assignment.

Today's Date:
Supplier	Invoice Date	Amount	Terms	Invoice Due Date	Days Overdue?
Inks R Us	15-12-2017	4,300.00	30	14-01-2018	44
Denman Papers	08-01-2018	950.00	60	09-03-2018	-10
Cartridge World	09-11-2017	8,450.99	60	08-01-2018	50
Viking Direct	05-02-2018	3,112.50	90	06-05-2018	-68
Office World	22-12-2017	1,875.00	30	21-01-2018	37
JT Cartons Ltd	24-02-2018	430.25	60	25-04-2018	-57

2. In cell B1 add a special date function that will always show the current date whenever you open the file:

3. In cell E5, create a formula that will calculate the invoice due date. Use the following to help you:

Invoice Due Date = Invoice Date + Terms

4. In cell F5, create a formula that calculates how many days overdue (or under-due) an invoice might be. Use the following to help you:

Days Overdue = Today's Date - Invoice Due Date