Excel formula to show sales per month from movement per day

Advanced Excel formula needed to show sales per month with a line chart to show month date vs sales per month

Example data set attached. This is sales data for one product. I have 22 products from this supplier. I need to use this data to forecast stock ordering for next year by analyzing sales per month. The chart will therefore need to show sales trend lines for 22 products.

I understand there is a formula which can find the start and end of each month, i.e. 1st March to 31st March and then total how many sales for that month. I then need the line chart on the same sheet.

It would also be useful to have total sales per year

I may send the other 21 products to add to this sheet after this 1st product is set up.