#Working days left in 2021 professional#
#Working days left in 2021 series#

#Working days left in 2021 series#

2įor many countries in the chart we don’t have long-run series going back to the 19th century. Before this revolution in working hours people worked as many hours between January and July as we work today in an entire year. In Germany, for example, annual working hours decreased by nearly 60% - from 3,284 hours in 1870 to 1,354 hours in 2017 - and in the UK the decrease was around 40%. In 1870, workers in most of these countries worked more than 3,000 hours annually - equivalent to a grueling 60–70 hours each week for 50 weeks per year.īut we see that today those extreme working hours have been roughly cut in half.

The chart shows that average working hours declined dramatically for workers in early-industrialized economies over the last 150 years. The data comes from research by the economic historians Michael Huberman and Chris Minns, who have brought together evidence from historical records, National Accounts data, and other sources. We show annual totals, so the trends account for changes in both the length of working days as well as the number of days worked through the year. You can add or remove countries by clicking

The chart here shows average working hours since 1870 for a selection of countries that industrialized early. Women in the US: Weekly hours dedicated to home production by age group.Weekly hours worked by age group, United States.Weekly hours dedicated to home production in US, by gender.Time spent on activities on an average day, by sex, Sweden.Time spent on activities in an average day, males.Time spent on activities in an average day, females.Time spent on activities in an average day.Participation time in employment per day.Men in the US: Weekly hours dedicated to home production by age group.Hours spent in market and non-market work per week, by sex, United States.Days off from work for vacations and holidays.Average hours worked per person employed.Average hours of work per week, by industry.Average daily hours worked, by industry, United States.Average daily hours of work, by occupation, United States.Average daily hours of work in winter, by industry.Average daily hours of work in summer, by industry.Annual working hours per worker, various sources.I then plotted these results and found the resulting pie chart looks eerily similar to Pac- Man chasing and gobbling up hours (especially after adding the eye and yellow hour balls).

I also calculated the number of business days (excluding federal holidays) remaining until my anticipated retirement at age 65 (Dec. 11, 1982) to the day I wrote this column as 9,064.

#Working days left in 2021 professional#

For example, I calculated the number of business days (excluding federal holidays) from the day I started my professional career (Jan. The tool's power becomes more obvious when multiple years are involved. Keep in mind that some businesses give employees Friday or Monday off if the actual holiday is on a weekend, and Excel does not account for this. In case you are wondering why the total business days declined by only eight days from 260 to 252 when 10 holidays were subtracted, the reason is that two of those holidays fall on weekends and, therefore, were already excluded from the original calculation mention above. The formula is identical to the solution described above, except this time the 10 federal holidays are highlighted at the end of the formula, which reads as follows: =NETWORKDAYS(B3,B4,B6:B15).Īs you can see in the screenshot above, 2017 contains 252 total business days, excluding weekends and federal holidays. The example below depicts the start and end dates for the time period in question, along with a list of the 10 standard federal holidays, in cells B6 through B15. Excel cannot automatically determine whether these specific holidays or others are to be excluded from your calculation therefore, you must enter all holiday dates yourself.) 24, 2017, (the day after Thanksgiving) as a state holiday. As examples, the District of Columbia celebrates Emancipation Day on April 16, 2017, as a district holiday, and both Indiana and West Virginia celebrate Lincoln's Day (for Abraham Lincoln) on Nov. (You must type in the holiday dates you want to exclude because there are more than 200 official holidays, and Excel does not know which ones you want to exclude. To apply this additional functionality, you must first type in all the specific holiday dates you want excluded. You may also want to calculate the number of business days in a given period excluding holidays the NETWORKDAYS function can also perform this calculation.