Return 1 or 0 based on Date Range

In my monthly version, I used only the date for the first day of the month for all calculations. In the weekly version, you added a column for Week End Date and tried to modify your formula to take that into account. I didn't try to figure out what was wrong with your formula. It was easier to just copy over the formula used for months. My column is the one highlighted in yellow.

If it works for you, just delete your own column for A, then copy over my column. But.

One problem with this kind of copying is that the source data has data in every other column, but your formulas are in adjacent columns. So you can't just copy the formulas into the next column. One trick for doing this kind of copying is to insert a blank column between every column where you are going to put the formulas, then copy the column for A into the desired columns. They will refer to the correct source columns. Now you can delete the extra blank columns and your formulas will still point to the right place.