insert a planner in your excel sheet

%3CLINGO-SUB%20id%3D%22lingo-sub-2398293%22%20slang%3D%22en-US%22%3Einsert%20a%20planner%20in%20your%20excel%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2398293%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1066581%22%20target%3D%22_blank%22%3E%40muraly64%3C%2FA%3E%20How%20to%20insert%20a%20planner%20%2F%20calendar%20in%20an%20excel%20sheet.%20This%20is%20required%20to%20prepare%20a%20diary%20for%20teaching%20in%20different%20subjects.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2398293%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2398374%22%20slang%3D%22en-US%22%3ERe%3A%20insert%20a%20planner%20in%20your%20excel%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2398374%22%20slang%3D%22en-US%22%3EThere%20are%20multiple%20calendar%20templates%20available%20for%20Excel.%3CBR%20%2F%3E%3CBR%20%2F%3EBeyond%20that%2C%20however%2C%20it%20would%20be%20a%20lot%20easier%20to%20help%20you%20if%20you%20helped%20us%20by%20describing%20what%20your%20hypothetical%20planner%2Fcalendar%20might%20look%20like.%20At%20the%20very%20least%20a%20provide%20us%20with%20a%20sketch.%20Assuming%20you've%20at%20least%20attempted%20something%20manually%20in%20Excel%2C%20post%20that%20spreadsheet.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2398456%22%20slang%3D%22en-US%22%3ERe%3A%20insert%20a%20planner%20in%20your%20excel%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2398456%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1066581%22%20target%3D%22_blank%22%3E%40muraly64%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20Mr.%20John%20Alsdorf%20(%40mathetes)%20told%20you%2C%20what%20exactly%20do%20you%20want%20to%20accomplish%3F%3C%2FP%3E%3CP%3EAny%20file%20as%20a%20template%3F%3C%2FP%3E%3CP%3EHere%20are%20some%20templates%20to%20choose%20%2F%20think%20about%20%2F%20why%20not%20to%20use.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftemplates.office.com%2Fen-us%2FCalendars%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3ECalendars%20Templates%20for%20choice%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fexcel-calendar-templates-f2e7ffe9-41fa-4ce5-8278-cf92d3b66340%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EExcel%20calendar%20templates%3C%2FA%3E%3C%2FP%3E%3CDIV%3E%3CDIV%20class%3D%22appliesTo%22%3E%3CFONT%20size%3D%221%202%203%204%205%206%207%22%3E%3CSPAN%20class%3D%22appliesToItem%22%3EExcel%20for%20Microsoft%20365%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20class%3D%22appliesToItem%22%3EExcel%20for%20the%20web%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20class%3D%22appliesToItem%22%3EExcel%202019%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20class%3D%22appliesToItem%22%3EExcel%202016%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20class%3D%22appliesToItem%22%3EExcel%202013%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20class%3D%22appliesToItem%22%3EExcel%202010%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20class%3D%22appliesToItem%22%3EExcel%202007%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CP%3EMany%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Ftemplates.office.com%2Fen-us%2FCalendars%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ecalendar%20templates%3C%2FA%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Eare%20available%20for%20use%20in%20Microsoft%20Excel.%20A%20template%20provides%20a%20basic%20calendar%20layout%20that%20you%20can%20easily%20adapt%20for%20your%20needs.%3C%2FP%3E%3CP%3EAn%20Excel%20calendar%20template%20may%20have%20one%20or%20more%20of%20these%20features%3A%3C%2FP%3E%3CUL%3E%3CLI%3E%3CP%3ETwelve%20months%20in%20one%20or%20separate%20worksheets.%3C%2FP%3E%3C%2FLI%3E%3CLI%3E%3CP%3EThirteen%20months%20starting%20with%20July%20or%20August%20and%20ending%20with%20July%20or%20August%20of%20the%20next%20year%20to%20represent%20a%20school%20year.%3C%2FP%3E%3C%2FLI%3E%3CLI%3E%3CP%3ECalendar%20printing%20on%20one%20page%20or%20twelve%20pages%20(thirteen%20pages%20for%20school%20year%20calendars).%3C%2FP%3E%3C%2FLI%3E%3CLI%3E%3CP%3EDisplay%20of%20weekdays%20from%20Sunday%20to%20Saturday%20or%20from%20Monday%20to%20Sunday.%3C%2FP%3E%3C%2FLI%3E%3CLI%3E%3CP%3EPortrait%20or%20landscape%20orientation%20for%20printed%20pages.%3C%2FP%3E%3C%2FLI%3E%3CLI%3E%3CP%3EA%20ruled%20column%20for%20notes.%3C%2FP%3E%3C%2FLI%3E%3CLI%3E%3CP%3EA%20vacation%20planner.%3C%2FP%3E%3C%2FLI%3E%3CLI%3E%3CP%3ETo-do%20lists.%3C%2FP%3E%3C%2FLI%3E%3CLI%3E%3CP%3ETask%20trackers.%3C%2FP%3E%3C%2FLI%3E%3CLI%3E%3CP%3EBudget%20trackers.%3C%2FP%3E%3C%2FLI%3E%3CLI%3E%3CP%3EDaily%20schedule%20tracker.%3C%2FP%3E%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EDownload%20a%20calendar%20template%3A%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3EBrowse%20through%20the%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Ftemplates.office.com%2Fen-us%2FCalendars%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ecalendar%20templates%3C%2FA%3E%2C%20choose%20an%20Excel%20calendar%20template%20that%20is%20best%20for%20you.%20Click%20the%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EDownload%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Ebutton%20on%20the%20template%20page%2C%20open%20the%20template%20file%20in%20Excel%2C%20and%20then%20edit%20and%20save%20your%20calendar.%3C%2FP%3E%3CDIV%20class%3D%22ocpAlert%22%3E%3CP%20class%3D%22ocpAlertSection%22%3E%3CSTRONG%3ENote%3A%3C%2FSTRONG%3E%26nbsp%3BBy%20default%2C%20a%20template%20file%20download%20goes%20into%20the%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EDownloads%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Efolder%20on%20your%20computer.%20You%20may%20want%20to%20copy%20the%20template%20file%20to%20a%20different%20location%20so%20that%20you%20can%20easily%20find%20it%20later.%3C%2FP%3E%3C%2FDIV%3E%3CP%3ENeed%20more%20help%3F%3C%2FP%3E%3CP%3EYou%20can%20always%20ask%20an%20expert%20in%20the%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel%2Fct-p%2FExcel_Cat%22%20target%3D%22_blank%22%3EExcel%20Tech%20Community%3C%2FA%3E%26nbsp%3Bor%20get%20support%20in%20the%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgo.microsoft.com%2Ffwlink%2F%3Flinkid%3D827514%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EAnswers%20community%3C%2FA%3E.%3C%2FP%3E%3CH3%20id%3D%22toc-hId-2034864440%22%20id%3D%22toc-hId-2034864439%22%3ESee%20Also%3C%2FH3%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fcreate-a-calendar-by-using-a-template-91804e1f-360b-4bf9-b21d-103a25a84868%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3ECreate%20a%20calendar%20by%20using%20a%20template%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E*%20Kindly%20Mark%20and%20Vote%20any%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20Community%20members%20reading%20here.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

@muraly64 How to insert a planner / calendar in an excel sheet. This is required to prepare a diary for teaching in different subjects.

7 Replies
There are multiple calendar templates available for Excel.

Beyond that, however, it would be a lot easier to help you if you helped us by describing what your hypothetical planner/calendar might look like. At the very least a provide us with a sketch. Assuming you've at least attempted something manually in Excel, post that spreadsheet.

@muraly64 

As Mr. John Alsdorf (@mathetes) told you, what exactly do you want to accomplish?

Any file as a template?

Here are some templates to choose / think about / why not to use.

Calendars Templates for choice

 

Excel calendar templates

Excel for Microsoft 365 Excel for the web Excel 2019 Excel 2016 Excel 2013 Excel 2010 Excel 2007

Many calendar templates are available for use in Microsoft Excel. A template provides a basic calendar layout that you can easily adapt for your needs.

An Excel calendar template may have one or more of these features:

  • Twelve months in one or separate worksheets.

  • Thirteen months starting with July or August and ending with July or August of the next year to represent a school year.

  • Calendar printing on one page or twelve pages (thirteen pages for school year calendars).

  • Display of weekdays from Sunday to Saturday or from Monday to Sunday.

  • Portrait or landscape orientation for printed pages.

  • A ruled column for notes.

  • A vacation planner.

  • To-do lists.

  • Task trackers.

  • Budget trackers.

  • Daily schedule tracker.

 

Download a calendar template:

Browse through the calendar templates, choose an Excel calendar template that is best for you. Click the Download button on the template page, open the template file in Excel, and then edit and save your calendar.

Note: By default, a template file download goes into the Downloads folder on your computer. You may want to copy the template file to a different location so that you can easily find it later.

Need more help?

You can always ask an expert in the Excel Tech Community or get support in the Answers community.

See Also

Create a calendar by using a template

 

I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)

 

* Kindly Mark and Vote any reply if it helps please, as it will be beneficial to more Community members reading here.

@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.

 

 

@NikolinoDE 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.
Please see the file of diary attached to the reply given to @mathetes
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.
Please wait for a while. I shall let you know as to what exactly i am trying to do. At present, my effort may be labelled as trial and error.
Trial and error is a great way--seriously--to use things like Pivot Table in seeking to summarize a big database.