Want to know how many days you've worked in the company? In Excel, enter the start date and end date, and then use a networkdays function to easily handle it! Let's take a look at the specific approach.
Detailed Operation steps
Open a two-date worksheet with Excel2013, for example, now we want to calculate the number of days between the columns A and B, and then press ENTER when the C2 cell enters the function "=networkdays (A2,B2)."
At this point the C2 cell has calculated the number of days between the B2 and A2 dates, moves the mouse to the lower right of the C2 cell, presses the mouse when the cursor becomes a cross, and drags the function to the C10 cell, automatically populating the C10 cell.
After we release the mouse, we can see the calculation knot between days of different dates, the effect is as follows.
Tip: The NETWORKDAYS function calculates only days of the day, excluding national holidays and weekends.
Note : More wonderful tutorials Please pay attention to the triple Office software tutorial section, triple Computer office group: 189034526 welcome you to join