Oftentimes you will receive data that is overly general. Notice in the data table that begins in row $18,$ daily revenue is provided. However, your analysis calls for monthly and daily aggregation of the revenue data. In columns C and D of the data table, use the techniques you learned above to populate each row with the month and day of the week based on the date in column A$.$

In column E of the data table, note the target dollar value in cell E$16.$ In column E of the data table, create an IF formula that will display TARGET if the revenue in column B is greater than or equal to the target value in E$16,$ or MISS otherwise.

Revenue Pivot Table

In cell A$2$ in Pivot worksheet, create a pivot table based on the data table, that aggregates revenue by placing month in the columns and weekdays in the rows. Make sure Vales in the Pivot Table task pane is set to Sum of Revenue.

What is the lowest sum of revenue in the pivot table? $($Note: Conditional formatting can help!$)$