DISCOVER
×

How to Calculate Working Days

Updated February 21, 2017

Often it is important to know how many days an employee has worked in a certain period. This working time can be used to determine various government and company benefits. While there are several calculators which can be used to determine working time, you may want to do the calculation manually if your company takes into account time off and sick days in the number of working days.

Add up the amount of days in the period you are looking at. For example, if you are looking at the first quarter, you would add up the number of days in January, February and March to come up with 89 days.

Subtract the number of weekend days in that period. The year will determine how many weekend days there are, so make sure you have a calendar ready. Using the example above in 2010, there were 27 weekend days. Subtract that number from your total number to come up with 62 days.

Count the number of holidays and subtract those from the total in Step 2. This will depend on how many holidays your business observes. For example, if your company only observes major federal holidays (i.e. New Year's, Christmas, Fourth of July), there is only one lost day in the first quarter for New Year's Day. Subtract this number to get a total of 61 working days.

Subtract any days when you called in sick if your company doesn't count sick days in their working days calculation. This will give you the total number of working days in the period.

Tip

While there are several online calculators (Excel also has a way to make this calculation), it is a better option to do this by hand if possible. You will have better access to information and won't be relying on a computer which doesn't follow your companies rules and guidelines.

Warning

Make sure you count everything as accurately as possible. Even being a day off can affect how someone receives benefits.

Things You'll Need

  • Calendar
  • Calculator
  • Employee attendance record
bibliography-icon icon for annotation tool Cite this Article

About the Author

R.L. Cultrona is a San Diego native and a graduate of San Diego State University. She holds a Bachelor of Arts in theater, television and film with a minor in communications and political science. She began writing online instructional articles in June 2009.