Rolling Calendar

[uneek78]

How do I create a rolling calendar out of a yearly calendar I already have in excel? Or just how do I create one?

 

[DanWall]

What's a rolling calendar?

 

[uneek78]

My supervisor had an excel spreadsheet that went continuously. It appeared to pick up the correct months on its own and was continuous. I thought it was so neat.

 

[uneek78]

Maybe there is no such thing. I was hoping for code that would make the calendar continuous and hopefully let the dates adjust themselves correctly.

 

[DanWall]

My apologies for sounding ignorant, but I still have no idea what you're talking about...

Perhaps you could post an example?

 

[scott-atkinson]

You can write some VBA code that will change a dynamic calculation to pick up the current date plus a set amount of dates in the past.

But as previously said, if you post an example of what you are trying to do perhaps we can help.

 

[uneek78]

My supervisor isn't tech savvy and she called it that. And believed it went on forever. So I took it and ran w/ it, but I don't believe there is any such thing. BUT...........implied that there is code that could adjust dates and such according to real time? What is that code?

 

[boblarson]

You can set a calendar to be - let's say always a three month window - show a calendar control to be a month in the past and another a month in the future. This would be accomplished by using something like this:

Me.YourStartCalendar = DateAdd("m", -1, Date())
Me.YourEndCalendar = DateAdd("m", 1, Date())

And that would always give you a calendar based on today's date and when you moved into the next month it would display new dates.

For example, if you used the current date (April 6th) it would display
StartDate = March 6, 2009
EndDate = May 6, 2009

and then next month on, say May 1st it would show:

StartDate = April 1, 2009
EndDate = June 1, 2009

and so on.

 

[DanWall]

I think I understand.....
You could do something as simple as this....

a1: 1/1/09 (format to how you want it)
a2: =A1+1
a3: =A2+1
etc
etc