We Value Your Privacy

We and our partners use technology such as cookies on our site to personalise content and ads, provide social media features, and analyse our traffic. Click below to consent to the use of this technology across the web. You can change your mind and change your consent choices at anytime by returning to this site.

Update Consent
Loading ...

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.

Loading ...
  1. 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.

  2. 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.

  3. 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.

  4. 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.

  5. 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.


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

Loading ...

Things You'll Need

  • Calendar
  • Calculator
  • Employee attendance record

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.

Loading ...