Monthly calendar template in excel
I have created a monthly calendar template for you to download.
Download excel calendar template
Week starts with sunday
Monthly calendar template.xls
(Excel 97-2003 Workbook *.xls)
Week starts with monday
Monthly-calendar-template weekstart mon.xls
(Excel 97-2003 Workbook *.xls)
How the template works
Select a month and year. The cells (C2 and E2) are drop down lists. The calendar is instantly updated with dates. This makes it quick and easy to print months. You may have to adjust print area.
How I created the template
Adjust cell sizes
My calendar has seven columns and six rows filled with dates.
- Select the first seven columns
- Adjust width, I am using 128 px
- Select six rows
- Adjust height (90 px)
Create drop down lists
- Select cell C2
- Create a drop down list (Data validation)
- Select List
- In source field, type: January, February, March, April, May, June, July, August, September, October, November, December
Repeat with cell E2, in source field, type; 2011, 2012, 2013, 2014, 2015
Calculate start date
I created a second sheet "Calculation".
Formula in C4:
Cell range A1:A12 contains: January, February, March, April, May, June, July, August, September, October, November, December
Calendar formulas
- Select sheet1.
- Select cell A4, type in formula window: =Calculation!C4 + ENTER
- Select cell B4, type in formula window: =A4 +1 + ENTER.
- Select cell A5, type in formula window: =G4 +1 + ENTER
- Copy cell A5 and paste it down as far as needed.
- Select cell B4 and paste it to cell range B4:G9
Format cells
- Select sheet1
- Select cell range A4:G9
- Click "Top Align" button (Home tab, excel 2007)
- Click "Align text left" button (Home tab, excel 2007)
- Press CTRL + 1
- Click "Number" tab
- Click Category: Custom
- Type: D
- Click OK
Create named range
- Create named range, named "month"
- In Referes to: field, type: =DATE(YEAR(Calculation!$C$4), MONTH(Calculation!$C$4)+1, 1)
- Select cell range A1:A12 in sheet "Calculation"
- Type months in name box
Conditional formatting
- Select sheet1
- Select cell range A4:G9
- Click "Conditional formatting" button
- Click "New Rule.."
- Click "Use a formula to determine which cells to format"
- Type: =MONTH(A4)<>(MONTH(month))
- Click "Format..." button
- Click "Font" tab
- Select a color (grey)
- Click OK!
- Click OK!
Download excel calendar template
Monthly calendar template.xls
(Excel 97-2003 Workbook *.xls)
Related posts:
Monthly calendar template #2 in excel
Create a drop down calendar in excel
Weekly appointment calendar in excel
Recommended categories
Oscar, You have probably for got more Excel that I expect to learn but your web site is a great resource. I'm not sure where to add this, so bear with me. Calendaring. I like this look but for simplicity "lists work as well. Beautification can come later. Here's the challenge. Private calendar, School Calendar and a work planning calendar all on seperate sheets in one work book. One additional sheet contains the "Calendar year" starting Jan1 2013. I use "Weeknum" to extract the week number, then use "countif" to determine how many activities exisit on the various sheets for a given week. Now I'm stuck, I'm scared of VBA because I'm not well versed in the tool. Ideally, I would like a column for the week number and then "vlookup" and display all the dates and descriptions of what is happening during that week from all the various sheets. This involves adding rows. I don't see a formula for that. Then the second week, third week.... Does this make sense? Could you point me in the right direction? Further limited by excel2003 (2010 should arrive sometime this year.) Thanks
Rich,
I am not sure if this is exactly what you are looking for:
I am using random letters.
Download excel *.xls file
http://www.get-digital-help.com/wp-content/uploads/2011/01/Combine-Calendars.xls