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: 1 2 3 4 5 6 1 2 3 4 5 6 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
This question generated 12 answers. To proceed to the answers, click here.
This thread is current as of October 21, 2014.
For more resources for Microsoft Excel:
This article includes the following tags:
- Microsoft Excel