Hi,
I have weekly data that is based on Monday as the beginning of the week then counting 7 days to Sunday. My problem is that some weeks cross two months as in the example below week 1/29/2018. How do I write a formula to pick the amounts in each of the two months (Jan, Feb) and then show me the values in each of the two months that were in that particular week?
See example below.
Start Date End Date Month Sales $s Sales $ Jan Sales $ Feb
1/1/2018 1/7/2018 01JAN18 $1,523
1/8/2018 1/14/2018 01JAN18 $1,452
1/15/2018 1/21/2018 01JAN18 $1,892
1/22/2018 1/28/2018 01JAN18 $1,502
1/29/2018 2/4/2018 02FEB18 $1,587 ?? ??
2/5/2018 2/11/2018 02FEB18 $1,458
2/12/2018 2/18/2018 02FEB18 $1,478
2/19/2018 2/25/2018 02FEB18 $1,399
I have weekly data that is based on Monday as the beginning of the week then counting 7 days to Sunday. My problem is that some weeks cross two months as in the example below week 1/29/2018. How do I write a formula to pick the amounts in each of the two months (Jan, Feb) and then show me the values in each of the two months that were in that particular week?
See example below.
Start Date End Date Month Sales $s Sales $ Jan Sales $ Feb
1/1/2018 1/7/2018 01JAN18 $1,523
1/8/2018 1/14/2018 01JAN18 $1,452
1/15/2018 1/21/2018 01JAN18 $1,892
1/22/2018 1/28/2018 01JAN18 $1,502
1/29/2018 2/4/2018 02FEB18 $1,587 ?? ??
2/5/2018 2/11/2018 02FEB18 $1,458
2/12/2018 2/18/2018 02FEB18 $1,478
2/19/2018 2/25/2018 02FEB18 $1,399