CALENDARS/SCHEDULES

Y

YanYan

Every month I do the department schedules for 20+ employees. We use
individual Excel calendars. I am currently manualy updating the calendars and
schedules. Is there a way to have Excel automaticaly update the calendar
every month plus enter the schedule for me. For example, employee A has a set
Mon-Fri schedule but on certain days of the month it changes like 1st Monday
of the month there is a meeting at 9. Any suggestions?

MON TUE WED THUR FRI
ALL IN IN OFF OFF IN
1ST meeting at 9
2ND IN
3RD meeting at 9
4TH IN 1/2 day
5TH
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automaticaly create montly calendars for 30 employees 1
Dcounta 4
Printing recurring events first in a monthly layout 0
Printing recurring events first in a monthly layout 0
Individual calendars for 30 employees 0
Table into 3 column data 0
Payroll 2
vlookup help? 8

Top