Rolling 3 Month Calendar

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

Requires VBA. There is no way (that I know of) to automatically or selectively hide columns without an explicit Hide Column command, so you needs macros to figure out which columns to hide. Allow macros to run for this to work.

I used three rows to show the date: year, month, day. That allows the columns to be as narrow as possible. The entire date is stored for all three; formatting dictates which value is seen.

There are radio buttons in the upper left that will allow you to choose whether to show all dates, or only the current month plus the following two months.

To add more dates, select the last column and fill to the right.

Now that I've done all that I'm going to recommend you do this by using rows for dates instead of columns, because Excel 2003 is limited to 256 columns, which is doesn't even get you 9 months. (I'm assuming you aren't using this to track over 256 employees.)

EDIT: With all due respect to royUK I proceeded because I felt it was clear to me what you were looking for.

I produced a similar sheet, where employee requests for time off where in a table, and the calendar scrolled showing a 4-8 week period, always starting at the current date. the entire sheet used no macros only conditional formatting and a few fomulas to achieve the effect, in the exel 2007 version it also showed company holidays and weekends highlighted!

As the calendar is dynamic it will last for ever, all you have to do is update employee requests in the table!

if this sounds interesting I will dig through my archives and post the sheet (its on my desk top, I will have to blow the dust off it!)