Requirements

Sheet$1$ and Sheet$2$

The columns labeled Contract Date $($on Sheet$1)$ and Holiday Date $($on Sheet$2)$ need to be formatted to properly show up as dates.

The company does not work on the owner's birthday. Since you and the owner share the same birthday, please add your birthday to the holiday table on Sheet$2.$ The year you put with your birthday needs to correspond to the years in which these projects are being completed. Put at least two years worth of birthdays on the list.

On Sheet$1,$ create a column that looks up the number of days each house plan takes to build from the table on Sheet$2.$

Create formulas $($in three additional columns$)$ to calculate the estimated completion date based on three different work schedules:

Calculate the completion dates for all homes using a workday function if we work normal workdays $($Monday to Friday$)$ during construction.

Calculate the completion dates for all homes if we also work on each Saturday during construction.

Calculate the completion dates for all homes if we also work on each Saturday and holiday during construction.

Sort the data by contract date with oldest contracts on top.

Lookup Sheet

Create a separate sheet that the office assistant can use. Use data validation to create a drop$-$down list of customer names $($it is most efficient to use a named range for the client list$).$ Create an input message for the drop down list.

Use lookup functions to display the address, house plan, contract date, build time, and estimated completion dates for:

Working Normal workdays $($Monday$-$Friday and taking holidays off$)$

Working Monday$-$Saturday and taking holidays off

Working Monday$-$Saturday and working the holidays

Finally, please label and the worksheet tabs appropriately. Ensure all columns are wide enough for the data contained in them. Format column headings to make the pages easier to read.