It comes with an advantage of excluding “Holidays” i.e. Holidays will not be counted as working days even those are falling between Monday to Friday.
This function really helps to in multiple ways, for example to calculate total pay days, prepare day wise work schedule, allocation and planning of project for an organization for a period. “Holiday” feature also helps to utilize the function in very effective manner.
Things To Remember
Please note that it will always returns to the whole number or integer value as output.
Also, Microsoft Excel calculate dates from 1st January 1900, if you use any date before than 1st January 1900 it will be shown as #VALUE! (Error)
Syntax: =NETWORKDAYS(start_date, end_date, [holidays])
Start_date argument is the date from which workday will be calculated. This date can be a working day or weekend, past day or future day.
End_date argument is the date to which workday will be calculated.
[holidays] Argument (Optional), Holidays argument is optional argument and used to excludes the holidays from NETWORKDAYS function output. We can give the complete range to exclude such days. Holidays are exception dates and such dates will not be counted as workdays (even those are falling on Monday to Friday)
We have taken 1st January 2019 as Start date and 31st December 2019 as End date and will be calculating net working days during a period of one year. Following the syntax, we have 261 net working days during that period
We have taken 1st January 2019 as Start date and 31st December 2019 as End date and have a list of holidays.
Net working days will be calculating considering 1st Jan 2019 as Holiday and total net working days for a year will be 260.
We mentioned that Microsoft Excel will calculate the date functions starting from 1st January 1900 and if we use any date prior 1st January 1900 this will show as #VALUE! (Error)
We have taken 1st January 1889 as Start date and 31st December 1889 and since it is prior to 1st January 1900 output is shown as #VALUE! (Error)
WEEKDAY function applies to a Date and returns the output for Day of the week. The output of the function varies from 0 to 7
An ultimate guide for basic user to understand Excel Vlookup function. VLOOKUP is a vertical lookup which helps the user to extract the values from other columns (leftmost) basis on matching column string.
Microsoft Excel “TODAY” function is used to get the current Date. It is very useful function and can be used in many ways. “TODAY Function” does not have any argument that makes this easy to apply and implement.
MAX function is used to get the largest number in range or list of values. MAX function has one required argument i.e. number1
TRIM function is used to remove the additional spaces (i.e. spaces before/after/between the words) except for single space between words.
AND, OR, NOT Functions” provide result in “TRUE” or “FALSE”. If the logical condition is correct and matching the parameters provided, then result would be “TRUE” or if logical condition is not correct and not matching the parameters provided then result would be “FALSE”