This tutorial explains how to determine the number of networkdays in a given year, which automatically excludes your lovely weekends and holidays for you. Then in the second part, I show you how to make a list of all the workdays in a separate column if that is something you are to need.

Oddly enough, Google Sheets performs the "Networkdays" formula the same as Excel. But in terms of listing the Workdays themselves, it differs quite a bit between Google Sheets and Excel. Check out the excel tutorial here:    • How to determine the number of workda...