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...