Excel Calendar
Posted on November 11, 2008
Filed Under Calendar | 7 Comments
This is another calendar I made, based on my perpetual monthly event calendar, where I put additional two mini layout month next to the main month. I put also a condition where the cell format of corresponding dates in those 2 months will be changed based on related events. I don’t know whether this will be more useful or not. But, I thought this is good as an accessories.
You can download the file here.
You can download the openoffice version here
Have a nice day.
You can read and download my other templates below :
Comments
7 Responses to “Excel Calendar”
Leave a Reply
-
About
This site provides hundreds of free originally designed excel templates for financial, budget, loan, sport, football, F1, calendar, planner, travel, event, and other purposes
-
Recently Written
- 2012/2013 Academic Calendar
- Credit Card Payoff Calculator
- UEFA EURO 2012 Schedule and Scoresheet
- 2012 Formula 1 Calendar and Championship Tracker
- Project Gantt Chart Template
- Simple To Do List
- Debt to Income Ratio Calculator
- Pregnancy Calendar
- UEFA Champions League Fixtures 2011/2012
- 2012 Calendar
- Serie A Fixtures 2011/2012
- Amortization Chart
- Eredivisie Fixtures 2011/2012
- Ligue 1 Fixtures 2011/2012
- Personal Budget
- Bundesliga Fixtures 2011/2012
- Yes No Chart
- Academic Calendar 2011/2012
- La Liga Fixtures 2011/2012
- Formula 1 2011 Schedule and Championship Tracker
- 2011 Calendars
- UEFA Champions League 2010/2011 Schedule
- Ligue 1 Schedule 2010/2011
- Serie A Schedule 2010/2011
- La Liga Schedule 2010/2011
- Bundesliga Schedule 2010/2011
- Eredivisie Fixtures 2010/2011
- World Cup 2010 Wall Chart
- World Cup 2010 Teams Biorythm
- Academic Calendar 2010/2011
- 2010 FIFA World Cup Office Pool
- Formula 1 2010 Schedule
- World Cup 2010 Schedule and Scoresheet
- Monthly Calendar
- Body Fat Calculator
- Bill Payment Calendar
- Net Present Value Calculator
- Waist to Hip Ratio Calculator
- TV Schedule
- Chinese Calendar
- Calories Burned Calculator
- Islamic Calendar
- Weekly Class Schedule
- 2010 Calendar
- Calorie Counter
- Household Expenses
- Weekly Calendar
- Calorie Intake Calculator
- BMR Calculator
- Binary Hexadecimal Converter
Your Excel calendar V1.3 is great. However, when viewing 2009 the small calendars on the right side of the screen show May as having 32 days.
Is there a fix that you’ve posted that I’ve missed?
B.
Hi Brian,
Thank you for your sharp seeing and sending me that information. I didn’t notice it until reading your comment. There is a cell reference mistake in that last row. It already fixed now. You can download the last version through the same link.
Regards
Great calendar, but I seem to have a problem now…when I change the starting month from I get “name?” for the the last two weeks of cells. When I hit ‘redo’ it does not fix. what am i doing wrong?
Hi Rakel,
You should activate the “Analysis ToolPack” Add-ins in your excel. By, default excel doesn’t activate this add-ins. Go to menu Tools > Add-Ins and you tick Analysis ToolPak and your problem will be solved.
Regards
Thanks, I will give it try. Rakel
Hi,
The calendar you have is great and works fine but allows only 3 events per day and i have more than 3 events to manage per day (maybe if i can have 5 events per day). I tried to copy the formula by adding another row in each day but it does not works. Please help on how to do this?
Thanks a lot
Gagan
If you don’t want to activate the Analysis ToolPack add-in in order for the EOMONTH function to work, you could substitute the following, for example:
Original formula:
=IF(K18″”,IF(DAY(EOMONTH(DATE($J$26,$K$26,1),0))=K18,”",K18+1),”")
Replacement formula:
=IF(K18″”,IF(DAY(DATE($J$26,$K$26+1,1)-1)=K18,”",K18+1),”")
This grabs the date of the first day of the next month, then subtracts 1 day from that to get the last day of the desired month. Even works for December!