Gross Profit in Pivot Table

I have two questions.
Is it possible to format column "C" in the Date tab to return the month based on column "D" and
Is it possible to get calculations like gross profit etc when using a pivot table?
I would like to get a report that looks like the tab "Desired Layout" but I don't have experience with formulas is Pivot tables.

Thanks,

Just to build on what protonLeah said, after you get the format issue fixed, you can either do your calculations in your table as I did, or you can do them as a calculated field within the pivot table. I have done up a pivot table using your data and attached it. One question, do you need the month in column c for anything in particular?