On the Summary sheet, you will be entering all the formulas. Cells to complete are filled with the light purple color. Hint: Use error checking as needed and$/$or display the formulas on$-$screen for easy viewing.

Cell B$2$ should use a function that will update the date to the current date every time the workbook is opened.