HOW TO USE THE FORMULA TO CALCULATE THE EFFECTIVE WORKING DAYS OF THE MONTH IN EXCEL SHEET? Ask the

The following is explained in the app help published by Microsoft:

Calculating the number of working days (i.e., from Monday to Friday) in a two-day period cannot simply be subtracted from one date to another. It requires a pre-written formula called the networkdays function, which counts the number of working days in a two-day period.

Assuming that today is June 9, 2004, your vacation still starts on August 21, 2004, but now you want to know how many working days you have left until the holiday starts. You can type the formula::

networkdays(a2,a3)

53 working days until the holiday. The values in cells A2 and A3 are parameters, i.e., information that tells NetworkDays that needs to be calculated. Parentheses separate functions from arguments. Commas in parentheses separate the different parameters.

You can get what you want with the following formula.

networkdays(today(),eomonth(today(),0))

You can use the if condition function, and the specific usage can be searched from the Internet to use it.

1. The employee's entry date and departure date are recorded in **, and the number of days the employee is on the job needs to be calculated.

2. First of all, in cell E2, enter the function formula: =round(if(d2<>"d2-c2,now()-c2),0)。

3. Press the "Enter" key to get the number of days of the first employee.

4. Select cell E2 and drag the fill handle in the lower right corner.

5. The number of days of employment of all employees can be obtained.

1. First of all, Jing Wang used the 2007 version of excel to create a new document, and then entered the start and end times.

2. Enter the formula =networkdays(b1,b2,b3:b9) in the target cell.

<>4. Then you can use Excel to automatically calculate the number of legal working days per month.

1. First of all, find the excel** software on the computer and carry out the excel**, as shown in the figure below.

2. At this time, the mouse selects the C2 cell, as shown in the following figure.

3. Then in this C2 cell, enter the formula: =DateDif(A2,B2,"d"), as shown in the following image.

4. Finally, press the Enter key to calculate the number of days the employee is 1827 days, as shown in the figure below.

Use the day and eomonth functions to find it.

Excel version reference: 2010

A1 is stored and b1 is used to find the data.

1. Select cell B1.

2. Enter the formula: =day(eomonth(a1,0)) 3. Enter, enter the date, and test.

Column grammar column (reference).

Refer to the topic where the column takes them for the cell or range of cells.

If the reference is omitted, it is considered to be a function column cell reference.

If a range of cells is referenced, the column function is input as a horizontal array, and the function will return the referenced column column labels, forming a horizontal array.

References cannot reference more than one region.

The above is Microsoft's official explanation.

Following my personal understanding of the future.

1: = column() returns the value of the cell with the input number of columns, and enters 42 in column d: = column(a1) returns 1 = column(b1) returns 23:

After applying the combined function = char(column()+64), you get one.

In cell A1, enter the formula and turn right to get BCD...

Pull sympathy will replace the ranks above the line to become calculated, backfill try to know.

A is listed as the date of entry (empty indicates the employee who joined the previous month), and B is listed as the date of resignation (empty indicates that he is still employed).

c1 Enter the following formula drop-down:

day(if(b1,b1,today())if(a1,day(a1))

The day of resignation is not counted as incumbency:

day(if(b1,b1,today())if(a1,day(a1),1)

It is advisable to give examples and sample results.

You take a screenshot and I'll help you solve it.

Software version: office2007

Here's how:1First, process the data of each month to the 1st of each month, as shown in column b in the following figure

2.Then enter the formula as follows:

Formula explanation: The first multiplier is to use weekday to get the number of days less than 6 in the month, that is, Monday to Friday; The second parameter is to use the month function to get the number of days in the month; SumProduct is then used to sum the product of the two multipliers to get the number of days from Monday to Friday in each month.

3.Pull down the padding and get the result:

2. Find and click the date and time display function list option, and find the indicated function option;

3. Click on the function pointed out, pop up the function window, set the start date as the cell date of the peer, and the number of months is 0 to represent the current month;

4. Find and click the OK button option to display the last day of the month on that date;

5. After that, the input box will be displayed, and then enter the day function in the input box, and then click the confirmation option;

6. Enter is displayed as the number of days, and other cells are calculated by using Excel's quick drop-down assignment method.

=day(date(2012,month(5)+1,0)) This formula is the number of days in May 2012.

The principle is: use the day function to calculate, but there is a trick here, you need to calculate June, and you need to enter 0 for the number of numbers

That is, enter the number of months in the next month, and the number of numbers is entered as 0

This is the total number of days in the month.

A method for determining the number of days in the month in which the specified date falls on.

1. Open the "Examples." xlsx", select the target cell, and click the "Insert Function" button in front of the bar.

2. In the pop-up Insert Function dialog box, set or select Category to Date & Time, and select the networkdays function in the Select Function list box.

3. After clicking the "OK" button, the "Function Parameters" dialog box will pop up. Set the start date to cell B15.

4. Set the end date parameter to C15 cell.

5. The holidays parameter can also be omitted, indicating that there is no holiday. If so, enter the number of statutory holidays and click OK.

6. You can see the number of valid working days between the two dates. Copy the formula to cell d18.

1. First of all, enter the date of start and the end date in Excel**.

2. Then click "FX" in the blank cell position and select the "NetworkDays" function.

3. Then input the function parameters according to the figure below, and convert them into the formula: =networkdays(a2,b2).

4. Click the OK button to get the total number of working days excluding statutory holidays.

The formula can be written.

networkdays(today(),a1)

networkdays

Returns the complete weekday value between start-data and end-data. Weekdays do not include weekends and specially designated holidays. Functions can be used.

networkdays, which calculates the accrued compensation of an employee based on the number of days they worked in a specific period.

If the function is not available and returns the wrong value name?, install and load the Analysis Tool Library to load macros.

Syntax networkdays(start date, end date, holidays).

Important You should use the date function to enter a date, or enter a date as a result of another formula or function. For example, use the function date(2008,5,23) input.

May 23, 2008. If the date is entered as text, the problem arises.

Start Date is a date that represents the start date.

end date is the end date.

holidays

Represents an optional area that is not made up of one or more dates in the work calendar, such as statutory holidays and other non-statutory holidays in provinces, municipalities, and national regions. The list can be a range of cells that contains dates, or an array constant that represents a sequence number of dates.

DescriptionMicrosoft Excel can store dates as serial numbers that can be used for calculations. By default, the serial number for January 1, 1900 is 1, while January 1, 2008

The serial number for the day is 39448 because it is 39448 days from January 1, 1900. microsoft excel for the macintosh

Use a different default date system.

If any of the parameters are invalid date values, the function networkdays will return an incorrect value of value!.

In cell b1, enter: =a1-now() Enter.

Here's how:

1. The first step is to open the excel software on the computer, and then enter the date of the start of the calculation and the date of the end in **.

3. After selection, enter the function parameters according to the following figure, and convert them to the formula: =networkdays(a2,b2).

4. Then click OK, and then you can get the total number of working days excluding statutory holidays, and the problem is solved.