update calendars in Excel?

[Guest]

Is there an easy way to update calendars from one year to the next? I know
there are templates posted for upcoming years, but I would like to be able
to update a template for attendance tracking of my employees and the only one
posted is for 2005. See Attendance calendar 2005 which is at:
Business and Legal > Meetings and Projects > Agendas and Minutes
and is in Excel 2003 format.

Thanks for any help.

 

[Gord Dibben]

Marsha

Next time, post the URL to the Template. Just copy it from the address bar and
paste to your message.

Now onto your question.

I downloaded this template and see no easy way to alter this particular calendar
template for a new year.

All days and dates are hard-coded so cells would have to be altered by hand.

Wait for next issue which I hope would include 2007


Gord Dibben MS Excel MVP

 

[Guest]

Marsha

Next time, post the URL to the Template. Just copy it from the address bar and
paste to your message.

Now onto your question.

I downloaded this template and see no easy way to alter this particular calendar
template for a new year.

All days and dates are hard-coded so cells would have to be altered by hand.

Wait for next issue which I hope would include 2007


Gord Dibben MS Excel MVP



Thank you for your prompt reply. That's what I was afraid of -- no easy way to convert the template to a different year. I kept checking to see if anyone had posted a 2006 version of that template, but they hadn't so now I'm hoping whomever first wrote it might do one for 2007. I'm a novice at working in spreadsheets so I have no clue how to accomplish it. I also didn't understand when you said to "post the URL to the Template". I guess I'm dense!!

Marsha