Home  >  Article  >  Software Tutorial  >  Graphical tutorial on calculating working days in Excel

Graphical tutorial on calculating working days in Excel

王林
王林forward
2024-04-25 14:55:33465browse

When dealing with complex tabular data, accurate calculation of working days is crucial. PHP editor Baicao specially prepared this tutorial to teach you how to easily calculate working days in Excel. Whether you are a novice or an experienced user, you can use this graphic tutorial to master the techniques and steps for calculating working days in Excel and solve problems at work. Read on to learn how to accomplish this computational task efficiently and accurately.

1. Let’s take the following table as an example. We will first list all the statutory holidays that we will experience, and pay attention to the pure date format.

Graphical tutorial on calculating working days in Excel

2. Then enter the function =networkdays in the cell of the working day. What should be filled in in the function is

Select the starting date [comma] Select the end date 【comma】. Finally, we select all the dates of legal holidays, press F4, and make the address an absolute reference.

Graphical tutorial on calculating working days in Excel

3. After filling in, press Enter and the working days will be calculated.

Graphical tutorial on calculating working days in Excel

But note that this networkdays function only calculates working days with weekend holidays. If there are odd and weekend holidays, then you need to use the =networkdays.intl(

function, The filling method is also the same. After selecting the date, the next step is to judge. If it is a weekend, enter 1; if it is only a weekend, enter 11. Finally, select the holiday date

.

The above is the detailed content of Graphical tutorial on calculating working days in Excel. For more information, please follow other related articles on the PHP Chinese website!

Statement:
This article is reproduced at:zol.com.cn. If there is any infringement, please contact admin@php.cn delete