Excel Formulas to Calculate the Working Days in a Certain Year!!

In the previous post, we have learned the formulas to calculate the total number of workdays per month in Excel. Likewise, here we will discuss the cute formulas to calculate the working days in a certain year in Excel. Let’s get them below!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

Generic Formula:

Use the below formula to calculate the total workdays in a year.

=NETWORKDAYS(DATE(year,1,1),DATE(year,12,31),holidays)

Syntax Explanations:

NETWORKDAYS – In Excel, the NETWORKDAYS Function helps to return the number of working days between two dates.
DATE – This function will combine three different values and returns them as a date. Read more on the DATE function.
Year – It represents the input on your worksheet.
Holidays – It specifies the holidays on your worksheet.
Comma symbol (,) – It is a separator that helps to separate a list of values.
Parenthesis () – The main purpose of this symbol is to group the elements.

Example:

Refer to the below example image.

Here we will enter the holidays in Column B.
Now we are going to calculate the total working days for a year which is given in Column D.

Select any cell and type the above-given formula.

Finally, press ENTER to get the result out, if you need, drag the fill handle over range to apply the formula.

Bottom-Line:

Here, we have described the cute formulas to calculate the total number of working days for a certain year in Excel. Hope you like this article. Please feel free to state your query or feedback for the above article.

Thank you so much for visiting *Geek Excel!! **If you want to learn more helpful formulas, check out Excel Formulas *!! **