Excel календарь 2013 года

63 Responses to “2013 Calendar – Excel Template [Downloads]”

1. Dibyendu Sharma says:

   Good one Chandoo!!

   Cheers!!

   Dibs  

2. Rahim says:

   Thanks 🙂

3. Bhavik says:

   Nice 1.

4. Jignesh says:

    
   Excellent

5. Harold says:

   simple always rocks inside ! ! !

6. Manoj Gupta says:

   Excellent

7. Krishna says:

   Great work chandu

8. madhu says:

   hi Chandoo
   i have a question — while this is an great calendar template, do you have one where the text/event appears in the the Monthly Calender (the one which prints to 12 pages)
   Thanks
   Madhu

   • • Srikanth Reddy says:

       Really greate Chandoo

9. Sunny says:

   Thanks! Awesome gift.

10. Lisa says:

    Not seeing the monthy calendar in this download. Just the 12 month, daily & mini.

11. Jason says:

    Hi Chandoo

    I have added the monthly calendar also to the events calendar. It is an awesome spreadsheet, thanx! One question as above, what is the quickest way to have the days coloured (maybe labelled?) for each monthly calendar to reflect the event colours of the ‘full’ tab? Looking for the quickest way to copy across the conditional formatting to the monthly tab also. 

    Thank again
    Jason 

    • @Jason: thanks. Since you and many others have asked for it, I modified the event  calendar to show monthly calendars with event colors too. Download it from here:

      http://img.chandoo.org/d/2013-calendar-with-event-planner-v2.xlsx

      Regarding your question:

      The quickest way to apply CF to monthly calendars is,

      1. Apply CF rules for 3 color shadings (vacations in blue, anniversaries in pink and important in orange) for Jan 2013 month alone.
      2. Then Edit the rules for Jan 2013 in CF rule manager screen.
      3. Change the range of cells for which this CF should be applied to and include ranges for rest of months by holding CTRL and selecting these additional ranges.
      4. Click apply.

      • Jason says:

        Thanks Chandoo! Much appreciated. I also just modified the event calendar myself to show calendars with events colours. I worked out how to merge the CF across to the Monthly calendar with no issues 🙂

        Jason 

12. Vandana says:

    Awesome

13. Laxman Bhasoriya says:

    Excellent… work..
    Good work Dear Chandoo.
    Thank you..

14. Chandoo,
    Thanks for building such a great resource and community on Excel. 
    My calendar is also focussed on events and holidays. User can enter up to 100 personal events that will be displayed on the calendar and also highlighted using conditional formatting. In addition, U.S. holidays are calculated and highlighted.
    The calendar can be customized for any year, starting with any month, and the week can start with any day.
    Available here: http://indzara.blogspot.com/2013/01/custom-printable-calendars-built-in.html
    Feedback from this great community is welcome. Thanks.

15. Nancy says:

    This is awesome, thank you!
    How do I change the titles of the event types?  Probably pretty basic, but I am far from being an Excel guru.  I love that it keeps count of the event types used in the notes area, it is great for keeping track of vacation time used.

16. […] 2013 Calendar – Excel Template […]

17. dIEGO says:

    Wow! 
    I was looking for it 4 a long time. I need this!!
    I change the colors and the labels to make it works in spanish
    Have a question
    How can i modify to have Mondays as first day of the week instead Sundays? 

    thank you so much!

18. Very useful resource, would be nice to collaborate with you on my new photo calendar website http://calendar.pdfcreations.com to customize events on pdf layouts.

19. your calendar helps me find certain at everything on my daily plans,  right on my workbook. thanks a lot.

20. Denice Longshaw says:

    Chandoo.  This is fantastic.  A nice addition to the new 2013 calendar.    Thanks for sharing the data and as usual THANKS.

21. slotbandit says:

    Hi Chandoo,
    Could you please let me know how to change your nice calendar just to have Monday as first day instead of Sunday ? Or can you please upload version with starting with Monday ? 
    Would appreciate this a lot !
    Great work btw !!
    rgrds,
    slotbandit
     

22. raghurama bahlan says:

    Hi CHandoo

     
    really good job,you are the best ,i will pass to visit you nexet week i m raghurama bahlan.

23. slotbandit says:

    anyone can help ? how to set Monday as first in Chandoo calendar ??

    • @Slotbandit
      On the Monthly Sheet
      Change B5
      From:=INDEX(m1_,1,(ROWS($B$5:B5)-1)*7+COLUMNS($B$5:B5))
      To: =INDEX(m1_,1,(ROWS($B$5:B5)-0)*7+COLUMNS($B$5:B5)-6)
      Make the same changes to the other months and calendars

      • slotbandit says:

        Thanks a lot Ian !! 🙂

         
        have a good day

24. Mo says:

    Hey i was just wondering how can i change the daily drop down menu to
    Appoinments
    Campaigns

25. DAV says:

    is it possible (or simple) to have the calendar start with a different month?

26. Patricia says:

    This is great!! I have MS excel 2010. I am trying to make a dropdown calendar. Having the toughest time with this. Co worker has MS Excel 2003 Same issue. Do you have something already made?  Would appriciate it!!

27. Jason says:

    This is fantastic, is there an academic version that goes from august ’13 — July ’14?

28. […] If your events span several months, then you can use formulas to generate calendar. […]

29. Hemant Rathi says:

    Dear Chandu,
    Really Awesome
    but I wnat to know how it convert or make 2014 calender, Pls give me suggestions.
    This is particular item which i saw last 6 month but you prove it again that you are chandu.
    Thanks Again
    Hemant Rathi
     

    • daws122 says:

      change 2013 to 2014 on the same spread sheet and everything changes.

    • Hemant Rathi says:

      Dear Chandoo,

      In this Excel Calender If i set up event date then it does not show in calender’s particular date.

      Pls check and confirm me.

      Regards

      Hemant

30. JohnC_UK says:

    Have you looked at the month of February when you change the year to 2026?
    The first week is all blank.
     

31. Kumar says:

    Hi, this template is very good. Thanks for sharing it across. I need one more modification. When we click on the date on the one page full calander, can it show the event planned on that day!

    Right now, the color of the day is changed to show the event but we need to browse to daily calander for looking at the event. Is it not!

    I also wanted to have notes column in the monthly calander so that we can record the daily tasks there.

    Thanks again,
    Kumar

32. Misha says:

    Thank you! Beautiful gift

33. Lea says:

    This is a fantastic tool — i was wondering if there was anyway to add more events or separate the combination of Vacation and Holiday?

    • Lea,
      Please take a look at my all-purpose calendar maker and let me know if that addresses your question. You can add up to (any) five types of events. In addition, weekends are also highlighted. You can customize the weekend dates too. You can add multiple events to a single day. However, I have limited the template to only 100 events as all the events have to be displayed on the 12 month calendar.

      There is more customization available in the template. I hope you find it useful.

      http://indzara.blogspot.com/2013/06/AllPurposeCalendar.html

34. maddy says:

    I have the same question as Lea but with further additions. i.e. is there a way to :
    1. Add multiple events to a single date
    2. Show all the events in the Calendar with the corresponding colour in that cell (i.e. if there is a public holiday, birthday, and anniversary all on the same day, can it get reflected in the calendar)
    3. if i were to add a list of events (e.g. public holidays) to the list; can i update the list chronologically again

    Thanks!!
    Madhu

    • Hello Madhu,

      Please see my comment above for my response to Lea’s question. In my all-purpose calendar maker excel template, you can add up to (any) five types of events and each type is assigned a different colour. You can add multiple events to a single day. If multiple events happen on the same day and they belong to different event types (for example, holiday and birthday), the colour of the higher priority event type is displayed on the calendar. You control the priority (for example, birthday over holiday) in the template.

      I couldn’t understand your third question. Please explain.

      http://indzara.blogspot.com/2013/06/AllPurposeCalendar.html

35. maddy says:

    Hi Indzara
    Thank you for the template. its closer to what i need barring 1 thing.
    Currently the cell with the Date changes colour based on priority set for the event. But i need the actual cell with the event to be colour-coded. So if I have 3 events on the same day then each cell should be coloured differently and i’ll have 3 different coloured cells for the same date.
    Possible?
    Thanks!!

    • indzara says:

      Hello Maddy,
      Thanks. I would like to make sure that I understand your question. On my 12 month calendar (which prints on one page), I display all the event names and dates on the right side of the calendar. I also display the type of event, but I don’t colour-code them. Is that what you are referring to? If so, that can be easily done. I chose not to do that, because I thought it would be too distracting to have so many cells coloured (with different colours) on one page. Please let me know.

36. Hemant Rathi says:

    Dear Chandoo,

    Calender is awesome but……

    I have download this calender and also set the event but i could not be able to get when i click on selected date.

    Pls tell me complete way to process it.

    Thanks

    Hemant

37. maddy says:

    Hi Indzara
    I mean i need the cells to reflect the colour in the «Monthly_Calendar». At the moment only the cell with the Date changes colour, but i need the cell with the event to change colour too.
    Thanks

38. Hemant Rathi says:

    Hi Chandoo,

    I Download the calender but i face problem and that is:::
    If i set a event or important date by set up date then i am not be able to find on calender that event,

    Say i set for 19th july Birthday then icheck in calender then no alert oe message show.

    Pls sort out my problem so i can use the same.

    Thanks

    Hemant Rathi

39. daws122 says:

    How did you set the boarders? On the Full tab it doesn’t go beyond column AC? How did you do that?

    • daws122 says:

      Found out.

      Shift+Ctrl+arrow direction.

40. Hemant Rathi says:

    Dear Chandoo,

    Your Calendar is awesome,
    But i want to know that if i set up a event in a particular date then event should be display on front of calendar ie. highlighted or display seprately; I have tried but could not see, so pls check and revert me.

    Thanks & Regards

    Hemant

41. Jimmy says:

    this is so efin good!

42. Bird says:

    Hi Chandoo,

    Your calendar excel is awesome! But if I would like to change marked color in each condition in daily. How to do it?
    Thank you.

    The best regards,

    Bird

43. jon says:

    Whilst having events highlighted i still found that i was using the daily tab to see what they are.
    On the Daily tab I added a row count on todays date
    =MATCH(TODAY(),C:C,0)-1
    then added some an offset for the next 30 days
    =OFFSET(C1,$N$12,0,,)
    and an offset for the next 30 «notes»
    =IF(OFFSET(E1,$N$12,0,,)=0,»»,OFFSET(E1,$N$12,0,,))
    (this removes the 0 from the next step)
    Then picture linked these to the front page. Now everyday i can see what is coming up in the next month

44. Val says:

    this may be late in the year, but i was looking for calendars and came across a few of which, this one totally rocks.. Thanks Chandoo!

45. Liam says:

    Hi Chandoo,

    That looks great. Is there a way to set up a CF formula for a bi-weekly week pay schedule? 🙂 Many thanks if you could help me on this!

46. Suraj says:

    Hi Mr. Chandoo,

    I am a beginner in excel. So please excuse my stupid questions:

    1. I have downloaded this calender; but when I am clicking the highlighted dates events are NOT coming below the «Notes»…

    2. What I have to do to change «important» «Vacation», «Holiday» etc to something else?

    Regards

47. Mel says:

    Hey! This is a great calendar!

    I was wondering if there’s an easy way to view the notes on the events when you click on the cell in the full calendar tab.

    Thanks!

48. Brianna says:

    How do I get out of edit mode so I can actually use the buttons?

49. Arun says:

    How do I add one more event in the calendar like Public holidat

Leave a Reply

Содержание

• Создание различных календарей
  • Способ 1: создание календаря на год
  • Способ 2: создание календаря с использованием формулы
  • Способ 3: использование шаблона
• Вопросы и ответы

Коллеги,

я заинтересовался задачей использования формул для расчета количества рабочих дней.
В Excel (2013) есть две удобные функции РАБДЕНЬ() и РАБДЕНЬ.МЕЖД() — предназначенные именно для этой цели. Насколько я могу судить их отличие в том, что обычная функция считает выходными днями субботу и воскресенье, а вторую можно заставить считать выходными разные дни недели.

Вопрос заключается в том, что на некоторые выходные дни могут переноситься рабочие (особенно много их было в 2012 году, а после того рабочей стала лишь суббота 20.02.2016). К сожалению, эти удобные формулы не умеют учитывать такие переносы (или же мне что-то не известно).

Я даже попытался вручную прописывать все выходные и праздничные дни в году, исключая переносы руками — что мне ужасно не нравится. Но использовать эти формулы не получается…

Сталкивался ли кто-нибудь раньше с подобной задачей? Каким образом выходили из положения?
Или у кого-нибудь есть идеи как побороть такую проблему?

Ладно бы, эти дни были стабильными из года в год…
Без доп. таблицы праздников и перенесенных праздников — ерундовая затея. Вы же календарь будете использовать не один год.
С таблицами все намного проще, не нужны ни РАБДЕНЬ, ни РАБДЕНЬ.МЕЖД.

Печально.
Мне как раз понравился функционал этих функций… жалко, что придется отказаться от их использования…

Кому как… Я их вообще не использую )