Determine what days fall in which week based on knowing only the Month and Year

[Tyron]

Hey guys,

I was wondering if it were possible (with NO VBA) to have the month and year in two cells and in another 5 cells indicate the days in each week. There is room to have as many helper cells as necessary.

Below find an example of the before and after:

	A	B	C	D
1	October	2014
2	Week1:
3	Week2:
4	Week3:
5	Week4:
6	Week5:

<tbody>
</tbody>

	A	B	C	D
1	October	2014
2	Week1:	09/29-10/03
3	Week2:	10/06-10/10
4	Week3:	10/13-10/17
5	Week4:	10/20-10/24
6	Week5:	10/27-10/31

<tbody>
</tbody>

As you can see this basically emulates the calendar on your computer except it only indicates the range between Monday and Friday.

I am open to the VBA resolution if there is no FORMULA only resolution, but am trying to avoid if possible so I don't have to change worksheet into a macro enabled worksheet.

Thanks in advance

Ty

 

[barry houdini]

I edited my previous answer to show formulas that should work for those locations

 

[Tyron]

Hey barry houdini,

Figured it out. I had a portion of the 5th weeks formula pointing to H1 (blank cell) when it had to be H3 (New Cell location of the months name).

Everything works perfect now. Thanks again guys for all the help. You made something that looked difficult look easy.

later

Ty

Hey barry houdini,

Thanks. I appreciate it. This is a big help in making my worksheet that much more dynamic.

Now I just need to figure out how to move the cell locations around and it still work.

later

Ty