It is even more difficult to type a calendar yourself in excel than a Word. It is much easier to download a ready-made one for free. And having already opened it on your computer, change what you don’t like.
This calendar is simply unique. Except for its brilliance and perfect execution. In one click, its grid is rebuilt for the required year. See the two arrows to the right of 2017? It is they who move through the years. Up arrow - adds year, down arrow - subtracts.
The seasons of the year are highlighted with the corresponding colors, all Saturdays and Sundays are marked in red. Days from the previous or next month are marked in light gray. In the upper right corner there is a switch for the first day of the week - Sunday.
You can download the calendar for excel absolutely free -
A simple Excel calendar for 2017
The calendar is arranged in two columns for 6 months. Style is blue. Weekends and holidays are not allocated. Formulas are not spelled out, only alphabetic and numeric cells. After downloading this format, you can start changing it to fit your needs.
Download the calendar in xls for the academic year 2017-2018
(PDF, 30 kb)
Production calendar- a document defining the norms of working hours, indicating weekends, holidays and pre-holidays. Based on this data, work schedules are drawn up, including a document for recording the actual hours worked, the data of which at the end of the period determine the amount of wages. Our calendar is formatted in such a way that it is easy and understandable to navigate in it even for an inexperienced accountant or personnel officer.
Quarterly production calendar for 2017 with a 5-day week
31 - holiday
31 - pre-holiday day
31 - day off
31 - working day
Short version
Q1 2017
January | ||||||
Mon | tue | Wed | th | Fri | Sat | sun |
---|---|---|---|---|---|---|
26 | 27 | 28 | 29 | 30 | 31 | 1 |
2 | 3 | 4 | 5 | 6 | 7 | 8 |
9 | 10 | 11 | 12 | 13 | 14 | 15 |
16 | 17 | 18 | 19 | 20 | 21 | 22 |
23 | 24 | 25 | 26 | 27 | 28 | 29 |
30 | 31 | 1 | 2 | 3 | 4 | 5 |
February | ||||||
Mon | tue | Wed | th | Fri | Sat | sun |
---|---|---|---|---|---|---|
30 | 31 | 1 | 2 | 3 | 4 | 5 |
6 | 7 | 8 | 9 | 10 | 11 | 12 |
13 | 14 | 15 | 16 | 17 | 18 | 19 |
20 | 21 | 22 | 23 | 24 | 25 | 26 |
27 | 28 | 1 | 2 | 3 | 4 | 5 |
March | ||||||
Mon | tue | Wed | th | Fri | Sat | sun |
---|---|---|---|---|---|---|
27 | 28 | 1 | 2 | 3 | 4 | 5 |
6 | 7 | 8 | 9 | 10 | 11 | 12 |
13 | 14 | 15 | 16 | 17 | 18 | 19 |
20 | 21 | 22 | 23 | 24 | 25 | 26 |
27 | 28 | 29 | 30 | 31 | 1 | 2 |
II quarter 2017
April | ||||||
Mon | tue | Wed | th | Fri | Sat | sun |
---|---|---|---|---|---|---|
27 | 28 | 29 | 30 | 31 | 1 | 2 |
3 | 4 | 5 | 6 | 7 | 8 | 9 |
10 | 11 | 12 | 13 | 14 | 15 | 16 |
17 | 18 | 19 | 20 | 21 | 22 | 23 |
24 | 25 | 26 | 27 | 28 | 29 | 30 |
May | ||||||
Mon | tue | Wed | th | Fri | Sat | sun |
---|---|---|---|---|---|---|
1 | 2 | 3 | 4 | 5 | 6 | 7 |
8 | 9 | 10 | 11 | 12 | 13 | 14 |
15 | 16 | 17 | 18 | 19 | 20 | 21 |
22 | 23 | 24 | 25 | 26 | 27 | 28 |
29 | 30 | 31 | 1 | 2 | 3 | 4 |
June | ||||||
Mon | tue | Wed | th | Fri | Sat | sun |
---|---|---|---|---|---|---|
29 | 30 | 31 | 1 | 2 | 3 | 4 |
5 | 6 | 7 | 8 | 9 | 10 | 11 |
12 | 13 | 14 | 15 | 16 | 17 | 18 |
19 | 20 | 21 | 22 | 23 | 24 | 25 |
26 | 27 | 28 | 29 | 30 | 1 | 2 |
III quarter 2017
July | ||||||
Mon | tue | Wed | th | Fri | Sat | sun |
---|---|---|---|---|---|---|
26 | 27 | 28 | 29 | 30 | 1 | 2 |
3 | 4 | 5 | 6 | 7 | 8 | 9 |
10 | 11 | 12 | 13 | 14 | 15 | 16 |
17 | 18 | 19 | 20 | 21 | 22 | 23 |
24 | 25 | 26 | 27 | 28 | 29 | 30 |
31 | 1 | 2 | 3 | 4 | 5 | 6 |
August | ||||||
Mon | tue | Wed | th | Fri | Sat | sun |
---|---|---|---|---|---|---|
31 | 1 | 2 | 3 | 4 | 5 | 6 |
7 | 8 | 9 | 10 | 11 | 12 | 13 |
14 | 15 | 16 | 17 | 18 | 19 | 20 |
21 | 22 | 23 | 24 | 25 | 26 | 27 |
28 | 29 | 30 | 31 | 1 | 2 | 3 |
September | ||||||
Mon | tue | Wed | th | Fri | Sat | sun |
---|---|---|---|---|---|---|
28 | 29 | 30 | 31 | 1 | 2 | 3 |
4 | 5 | 6 | 7 | 8 | 9 | 10 |
11 | 12 | 13 | 14 | 15 | 16 | 17 |
18 | 19 | 20 | 21 | 22 | 23 | 24 |
25 | 26 | 27 | 28 | 29 | 30 | 1 |
IV quarter 2017
October | ||||||
Mon | tue | Wed | th | Fri | Sat | sun |
---|---|---|---|---|---|---|
25 | 26 | 27 | 28 | 29 | 30 | 1 |
2 | 3 | 4 | 5 | 6 | 7 | 8 |
9 | 10 | 11 | 12 | 13 | 14 | 15 |
16 | 17 | 18 | 19 | 20 | 21 | 22 |
23 | 24 | 25 | 26 | 27 | 28 | 29 |
30 | 31 | 1 | 2 | 3 | 4 | 5 |
November | ||||||
Mon | tue | Wed | th | Fri | Sat | sun |
---|---|---|---|---|---|---|
30 | 31 | 1 | 2 | 3 | 4 | 5 |
6 | 7 | 8 | 9 | 10 | 11 | 12 |
13 | 14 | 15 | 16 | 17 | 18 | 19 |
20 | 21 | 22 | 23 | 24 | 25 | 26 |
27 | 28 | 29 | 30 | 1 | 2 | 3 |
December | ||||||
Mon | tue | Wed | th | Fri | Sat | sun |
---|---|---|---|---|---|---|
27 | 28 | 29 | 30 | 1 | 2 | 3 |
4 | 5 | 6 | 7 | 8 | 9 | 10 |
11 | 12 | 13 | 14 | 15 | 16 | 17 |
18 | 19 | 20 | 21 | 22 | 23 | 24 |
25 | 26 | 27 | 28 | 29 | 30 | 31 |
Working hours for 2017 in the table
Below is a summary table of the number of calendar, working days, days off and the number of working hours for 40-, 36-, 24-hour working weeks by months, quarters, half-years and in general for the entire 2017. Save it to yourself.
Period | Number of days | Working hours per week | ||||
Calendar | Workers | Weekend | 40 hours | 36 hours | 24 hours | |
January | 31 | 17 | 14 | 136 | 122,4 | 81,6 |
February | 28 | 18 | 10 | 143 | 128,6 | 85,4 |
March | 31 | 22 | 9 | 175 | 157,4 | 104,6 |
1st quarter | 90 | 57 | 33 | 454 | 408,4 | 271,6 |
April | 30 | 20 | 10 | 160 | 144 | 96 |
May | 31 | 20 | 11 | 160 | 144 | 96 |
June | 30 | 21 | 9 | 168 | 151,2 | 100,8 |
2 quarter | 91 | 61 | 30 | 488 | 439,2 | 292,8 |
1 semester | 181 | 118 | 63 | 942 | 847,6 | 564,4 |
July | 31 | 21 | 10 | 168 | 151,2 | 100,8 |
August | 31 | 23 | 8 | 184 | 165,6 | 110,4 |
September | 30 | 21 | 9 | 168 | 151,2 | 100,8 |
3 quarter | 92 | 65 | 27 | 520 | 468 | 312 |
October | 31 | 22 | 9 | 176 | 158,4 | 105,6 |
November | 30 | 21 | 9 | 167 | 150,2 | 99,8 |
December | 31 | 21 | 10 | 168 | 151,2 | 100,8 |
4th quarter | 92 | 64 | 28 | 511 | 459,8 | 306,2 |
2 semester | 184 | 129 | 55 | 1031 | 927,8 | 618,2 |
2017 year | 365 | 247 | 118 | 1973 | 1775,4 | 1182,6 |
Files
Where and how are working hours applied
The working time is determined by the total number of hours that need to be worked out for a certain calendar period.
This indicator is used to approve the operating mode of the enterprise. The standard was developed taking into account the adequate distribution of the workload on the employee, preventing the employer's arbitrariness in terms of unauthorized increase in the number of working hours.
The Labor Code defines the working time as 40 hours per week for full-time employment (Article 91). Article 92 specifies the length of the shortened working day for adolescents under 16 years old, young people between 16 and 18 years old, disabled people, workers in hazardous industries and teachers.
The length of the working week for each category of citizens makes it possible to calculate the standard working hours for any month.
To do this, take the weekly norm of working hours, divide by 5 (the number of working days in a classic 5-day week), and then multiply by the sum of the working days of a particular calendar month (the total number of days minus weekends and holidays). The result is the norm of working hours for a given month.
Important! If there were holidays in the month, then it should be noted that the preceding weekday is always 1 hour shorter than the standard working hours. Thus, from the number of days obtained according to the indicated formula, one more hour must be subtracted for each day preceding the holiday.
In such a simple way, they get the number of hours that each employee is obliged to work to receive 100% of the salary. Based on the ratio of actually worked days to the standard for a particular month, the amount of wages is determined.
Working hours are used to organize the working regime of workers of any profession. The production rate used in manufacturing enterprises is, in fact, also a kind of working time rationing.
Holidays and shortened days according to the calendar
Below is a table from which you can clearly see that in 2017 there will be several "long" weekends. We also note that a shorter working day implies a 1 hour reduction in working time.
Postponed holidays in 2017
In 2017, January 1 and 7, and November 4 fall on weekends. Therefore, the transfers will be as follows:
- Sunday 1st January - Friday 24th February
- Saturday 7 January - Monday 8 May
- Saturday 4th November - Monday 6th November
This follows from the text of the Decree of the Government of the Russian Federation of August 4, No. 756, signed by D.A. Medvedev.
How and why are the days off?
There are 14 official holidays in Russia. Every year the Government adopts another resolution on their postponement. Such an event is being held in order to optimize the production calendar, to avoid a "ragged" work schedule. There are some simple rules for transferring:
- If the holiday falls on a weekend, it is postponed to the working day following this weekend.
- Working hours on the day before the holiday are reduced by 1 hour.
- In order for employees to be able to use their rest days rationally, weekends are sometimes postponed to weekdays. For the same reasons, it is allowed to postpone 2 weekends of vacations on New Year's holidays to any other month.
If you are from the Republic of Tatarstan or Bashkortostan:
Download calendar files for printing on a printer (A4 format)
Choose the most convenient format for printing your calendar:
DOWNLOAD CALENDAR FILES
Download production calendar for 2017 in horizontal orientation in PNG picture (on 4 pages)
Download quarterly 2017 production calendar in PDF (4 pages)
Save it, it will come in handy:
A production calendar with a six-day work week
The law provides that some enterprises can establish a 6-day working week (Art. 100 of the Labor Code of the Russian Federation). With such a work schedule, a day off will be Sunday (Article 111 of the Labor Code of the Russian Federation). In this case, the number of working hours on the eve of the day off cannot be more than 5 hours (Article 95 of the Labor Code of the Russian Federation). The limitation of 40 working hours with a 6-day working week remains (Article 91 of the Labor Code of the Russian Federation), therefore, in practice, the following scheme for distributing the number of hours by day of the week is often used, in order from Monday to Saturday: 7 + 7 + 7 + 7 + 7 + 5 = 40.
Files
Work schedules provided for by the Labor Code of the Russian Federation
The classic workflow model provides for a 5-day work week with 2 days off and a work day that lasts 8 hours. Not all enterprises can operate according to this scheme, so there are other options for the work schedule:
- Irregular working hours. For employees who are late at work after the end of the working day or come to work before it starts. The Labor Code of the Russian Federation strictly defines the list of positions for which this is permissible.
- Shift work. Introduced in establishments that have been operating longer than the maximum permissible daily work duration.
- Flexible schedule. Provides the ability to select the start time, end time and duration of the working day. The main thing is to work out the necessary rate of hours for a month and a year.
- A fragmented working day. A working day with a break breaking it into parts. In aggregate, it cannot exceed the duration of daily work permitted by the Labor Code.
Important! In work schedules other than the classic five-day schedule, the method of summarized accounting is used. In this case, it is not the weekly standard that is taken into account, but the monthly or even annual. The duration of the working time for the period, on average, should be equal to the length of the working day allowed by the Labor Code.
Why do you need a production calendar
Employees of personnel departments and accounting departments cannot do without a production calendar. However, this document is also used by other employees of various firms and enterprises. So, summing up, we can highlight what it is for:
- Scheduling of work. Using the production calendar allows you to take into account the number of weekends and work days in the month for which the schedule is being drawn up.
- Determination of the norm of working hours for each period. The specifics of calculating this indicator will be discussed below.
- Calculation of wages, vacation and hospital benefits. On the basis of the time sheet at the end of the period, the ratio of actually worked time and planned time is determined. These values help to calculate the amount of monthly payments and premiums.
- Vacation planning. Employees, having familiarized themselves with the production calendar, can choose the best time for vacation, determine the dates of short-term trips, purchase tickets and vouchers in advance.
Production calendar Is a document that is drawn up on the basis of. It includes accurate information on the number of business days. Holidays and holidays for every year. This takes into account the transfer of weekends to work days. Which are established by the Government of the Russian Federation. Due to this, the number of working days changes every year. It depends on the number of additional "non-working" days. Which appear when a holiday that falls on a weekend is transferred to a working day.
The personnel officer's calendar is a very important and necessary document. First of all, for accountants and personnel services. Since with it you can draw up an accurate work schedule. Calculate the number of hours worked. And, depending on their number, calculate the correct salary or bonus. Also, using the production calendar, various reporting documents are prepared in government agencies. And vacations and are calculated.
to the menu
PRODUCTION CALENDAR 2018 - 2019 free download for a 5 day work week.
The production calendar 2018 - 2019 is a document drawn up on the basis of the Russian Federation. The calendar contains accurate information about the number of working days, holidays and pre-holidays for each new year. Taking into account the changes in the transfer of days off to work days, which are established and approved by the Government of the Russian Federation. The production calendar 2018 - 2019 is, in fact, a "cheat sheet" in the work of a personnel officer and a payroll accountant. That is, therefore, the important information that is given in this production calendar for a 5-day work week. It is designed to help you avoid errors in payroll. In addition, it will facilitate the calculation of working hours, sick leave or vacation.
In the published production labor calendar of the personnel officer in Word format. You will find information about the number of working days and weekends, holidays, the number of working hours in the quarter, half of the year and in general in 2019 - working hours for 2019.
Download with weeks printable production timesheet calendar 2019 with a five-day working week, A4 format, approved by the government of the Russian Federation, with holidays and weekends, as always, you can completely free of charge using the link below.
Production calendar 2019
open / close documentProduction calendar 2018
open / close documentNote: Watch in large format
Note: Download the Production Calendar for 2018 in Word format
2017 production calendar
open / close documentNote: Download the 2017 production calendar in Word format
Production calendar 2016
open / close documentProduction calendar 2015
open / close documentProduction calendar 2014
open / close documentto the menu
Working hours for 2019 - 2020, 5 days working week
Currently, the Procedure for calculating the norm of working hours for certain calendar periods of time (month, quarter, year) is in force. Depending on the established working hours per week. Approved by the Order of the Ministry of Health and Social Development of Russia dated August 13, 2009 No. 588n. In accordance with this Procedure, this rate is calculated according to the estimated schedule of a five-day working week. With two days off Saturday and Sunday. Based on the duration of daily work (shift), for example.
- with a 40-hour work week - 8 hours,
- with a 36-hour work week - 7.2 hours;
- with a 24-hour work week - 4.8 hours.
Working hours for 2019. 5 day work week
open / close documentNote: Download the 2019 production calendar in Word format
Working hours for 2018. 5 day work week
open / close documentWorking hours for 2017. 5 day work week
open / close documentWorking hours for 2016. 5 day work week
open / close documentWorking hours for 2015. 5 day work week
open / close documentWorking hours for 2014. 5 day work week
open / close documentto the menu
The number of days off, holidays in 2019 - 2020
The production calendar shows the working hours for months, quarters and 2020. Generally based on 40, 36, and 24 hour workweeks. And also the number of working days and days off with a five-day working week with two days off.
For example, taking into account the transfer of weekends, we will have almost the same rest as before. There will be fewer New Years holidays. But there are more May ones. In total, it turns out that in addition to holidays and regular weekends, Russians will have another 28 days to rest. The employees 'New Year holidays were 8 days - from January 1 to January 8, 2019. In May, the duration of the workers' rest associated with the Spring and Labor Day will be 4 days - from May 1 to May 4. And the rest periods associated with the celebration of Victory Day will be 3 days - from May 9 to 11. Day of National Unity - 4 days (from 1 to 4 November). In this case, the norm will be observed. According to which the duration of a weekly uninterrupted rest should not be less than 42 hours.
The production calendar shows the norm of working hours for months, quarters and a year as a whole for 40-, 36- and 24-hour work weeks. And also the number of working days with a five-day working week with two days off. In accordance with the current regulation, the norm of working time for certain periods of time is calculated according to the estimated schedule of a five-day working week with two days off. On Saturday and Sunday. Based on the following duration of daily work (shift).
- with a 40-hour work week - 8 hours, on pre-holiday days - 7 hours;
- if the working week is less than 40 hours - the number of hours. Obtained by dividing the established duration of the work week by five days. On the eve of non-working holidays, the working time is reduced by 1 hour.
The working time norm calculated in the indicated order applies to all modes of work and rest.
In January 2019, with a five-day working week with two days off - 15 working days and 16 days off. Including 8 public holidays on January 1, 2, 3, 4, 5, 6, 7 and 8.
The working time this month is.
- with a 40-hour work week - 120 hours (8 hours x 15 days);
- with a 36-hour work week - 108 hours (36 hours: 5 days x 15 days);
- for a 24-hour work week - 72 hours (24 hours: 5 days x 15 days).
In 2019, with a five-day working week with two days off, 247 working days. Including 5 pre-holiday days (April 30, May 8, June 11, November 3, December 31). And 118 days off, taking into account 14 public holidays (1, 2, 3, 4, 5, 6, 7 and 8 January, 23 February, 8 March, 1 and 9 May, 12 June, 4 November).
The working time is: