How to use fiscal calendar in excel

I need to create a summary report in excel using the below 2 data sheets. For one of the columns i need to calculate the dollar value of the parts shipped in a week of our fiscal calendar. The second sheet has the fiscal calendar stored.

enter image description here

enter image description here

From the below example period 7(JUNE) starts from 06/02/2018 and ends on 06/29/2018. This month has 4 weeks.

Week   Shipped
W1     $2827
W2     $13664
W3     $2111.25
W4     $443

By: saahar

Leave a Reply

Your email address will not be published. Required fields are marked *