$1\mathrm{.}7$ Create a named formula called "Invoice$\_$Due$\_$Date" that calculates the invoice due date for the date in whatever cell is just below it $($i$.$e$.$ this should work in any cell on any page in the workbook$).$

Invoices are due $45$ days after the Invoice Date.

Make sure it works on other worksheets in the workbook as well!

Dates in excel are just a number, in order for it to look like a date, the cell needs to be formatted. Do not worry about changing the format of the cell, as long as the number is correct, the named formula is working properly.

The result shofuld be an Excel date$/$time that could be used in other calculations.