This tutorial will show you how to use the "networkdays" and "workday" formulas in excel. Networkdays is a good starting point in the process because it will calculate the number of workdays you have in a given year (which eliminates weekends, and holidays assuming you have a list of holidays). With this number calculated you can then create a list of the actual workdays in a column using.

Hate work and want to know exactly how many days you'll have to work in the coming year? This is the tutorial you need, and maybe it can even help you in planning your next vacation