Forum Discussion
insert a planner in your excel sheet
muraly64 How to insert a planner / calendar in an excel sheet. This is required to prepare a diary for teaching in different subjects.
mathetes I have attached the excel file here. One Sheet contains data and another sheet contains table.
I shall further make additions to each subject as to what are the topics that shall be taught on each working day. Dates on which Various assessment test like First Unit Assessment, First Terminal Exam, Second Unit Assessment and Second Terminal Exam etc. And ultimately I want to get the diary printed wherein details of full years schedule of teaching (Topic-wise, subject-wise) and various exam and Holidays are all included.
And what exactly do you want done with all of this that you haven't already done with your pivot table? That looks like a reasonable solution. Also a little like "overkill"--i.e., given the repetitions between days of the week, weeks of the month, months of the year, I'm wondering what purpose all the detail serves.