Excel Templates | Excel Spreadsheets | Excel Calendar



Excel Calendar

Posted on November 11, 2008
Filed Under Calendar |



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.

Excel Calendar

[enlarge]

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 :

Tags: , , , , , , , , , , , ,

Comments

7 Responses to “Excel Calendar”

  1. Brian on January 11th, 2009 1:46 am

    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.

  2. admin on January 15th, 2009 2:48 pm

    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

  3. Rakel on May 7th, 2009 3:39 am

    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?

  4. admin on May 9th, 2009 2:22 pm

    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

  5. Rakel on June 1st, 2009 12:43 pm

    Thanks, I will give it try. Rakel

  6. Gagan on September 15th, 2009 3:14 pm

    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

  7. Chris on March 11th, 2010 10:45 pm

    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!

Leave a Reply