21
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

=NETWORKDAYS(DATE(year,1,1),DATE(year,12,31),holidays)
Refer to the below example image.



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 *!! **
21