update calendars in Excel?
 

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.

update calendars in Excel?
 

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

On Tue, 19 Sep 2006 01:37:01 -0700, MarshaB
wrote:

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.

update calendars in Excel?
 

"Gord Dibben" wrote:

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

On Tue, 19 Sep 2006 01:37:01 -0700, MarshaB
wrote:

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.

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