On the Renovations worksheet, in cell D6, enter a DATEDIF function based on the

On the Renovations worksheet, in cell D6, enter a DATEDIF function based on the

On the Renovations worksheet, in cell D6, enter a DATEDIF function based on the renovations started and renovations completed dates to determine the length in days of the expected renovation for The Musica Room.
Copy this formula through cell D10.
In cell G6, enter a formula to determine the room capacity that The Musica Room will hold based on the original capacity in cell F6 and the increase in capacity percentage in cell B13. Use absolute references where necessary.
Copy this formula through cell G10.
Modify the named range IncreaseInRevenue to reference cell B14 not B15.
In cell I6, using the named range in cell B14, enter a formula to determine the projected increase in revenue for The Musica Room based on the revenue figure in cell H6 and the increase in revenue percentage in cell B14.
Copy this formula through cell I10.
In cell B20, enter a function that will calculate the monthly payment for the loan amount in cell B17, based on the Annualized Rate in B18, and the number of years in the Term in cell B19. Display the monthly payment as a positive value.
Assign the named range RoomClassification to cell range A23:B26.
In cell J6, using a lookup function, enter a formula to determine the projected room classification based on the projected quarterly revenue after renovations in cell I6. Use the named range RoomClassification when entering this formula.
Copy this formula through cell J10
On the RoomAnalysis worksheet, in cell G7, determine the total charges for The Musica Room by using a SUMIF function. Use absolute references where appropriate. Copy this formula through cell G11.
In cell G16, determine the total count of The Musica Room usage by using a COUNTIF function. Use absolute references where appropriate. Copy this formula through cell G20.