![]() ![]() Holidays - an optional list of dates that should not to be counted as working days.A positive number returns a future date, a negative number returns a past date. Days - the number of workdays to add to / subtract from start_date.Start_date - the date from which to start counting weekdays.The first 2 arguments are required and the last one is optional: NETWORKDAYS.INTL - count weekdays between 2 dates with custom weekends. ![]() Excel NETWORKDAYS - count working days between 2 dates.WORKDAY.INTL - calculate workdays with custom weekends.Excel WORKDAY function - add or subtract workdays.In Excel 2010 and higher, more powerful modifications of the above-said functions are available, WORKDAY.INTL and NETWORKDAYS.INTL, which let you define which and how many days are weekend days.Īnd now, let's have a closer look at each function and see how you can use it to calculate working days in your Excel worksheets. ![]() Using the NETWORKDAYS function, you can calculate the number of workdays between two dates that you specify. The WORKDAY function returns a date N working days in the future or in the past and you can use it to add or subtract workdays to a given date. Microsoft Excel provides two functions specially designed for calculating weekdays - WORKDAY and NETWORKDAYS. This short tutorial explains the use of Excel NETWORKDAYS and WORKDAY functions to calculate workdays with custom weekend parameters and holidays. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |