Shaqada NETWORKDAYS ee Microsoft Excel waa shaqo taariikh iyo waqti soo celisa tirada maalmaha shaqada oo dhan inta u dhaxaysa Start_date iyo End_date . Shaqada NETWORKDAYS waxay ka reebaysaa maalmaha fasaxa ah ( Sabtida^(Saturday) iyo Axada^(Sunday) ) iyo taariikhaha lagu aqoonsaday fasaxyada. Haddii dooddu aysan ansax ahayn, shaqada NETWORKDAYS waxay soo celin doontaa qiimaha qaladka # QIIMAHA^(VALUE) .

Qaabka loo shaqeeyo NETWORKDAYS waa  NETWORKDAYS(start_date,end_date,[holiday]).

Erayga NETWORKDAYS waa:

• Start_date : Taariikhda matalaysa taariikhda bilawga ah. Waa loo baahan yahay.
• Dhamaadka_date^(End_date) : Taariikhda matalaysa taariikhda bilawga ah. Waa loo baahan yahay.
• Fasaxyada^(Holidays) : Taariikhaha laga saaray maalmaha shaqada ee jadwalka. Liisku wuxuu noqon karaa unugyo kala duwan oo ay ku jiraan taariikhaha ama nambar taxane ah oo metelaya taariikhda. Waa ikhtiyaari.

Sida loo isticmaalo shaqada NETWORKDAYS gudaha Excel

Fur Excel .

Miis samee ama fur miis jira.

Tababarkiisa, waxaan rabnaa inaan helno tirada maalmaha shaqada ee u dhexeeya taariikhda bilawga iyo taariikhda dhamaadka.

Gudaha qolka aad rabto inaad dhigto nooca natiijada:

=NETWORKDAYS(A2, B2)

• A2 waa bilowga_taariikhda^(Start_date) .
• B2 waa dhamaadka_taariikhda^(End_date) .

Riix Gelida ^(Enter)Keyboardka^(Keyboard) si aad u aragto natiijada oo hoos u jiid gacanta buuxinta si aad u aragto natiijada kale ee shaxda.

Waxaan rabnaa inaan helno tirada maalmaha shaqada inta u dhaxaysa taariikhda bilawga iyo dhamaadka taariikhda fasaxa sida maalmo aan shaqaynayn.

Gudaha qolka aad rabto inaad dhigto nooca natiijada:

=NETWORKDAYS(A2, B2, H2 )

H2 waa Fasaxa^(Holiday) sida maalin aan shaqayn; waa ikhtiyaari.

Kadib taabo furaha Gelida^(Enter) si aad u aragto natiijada.

Waxaa jira laba hab oo kale oo loo isticmaalo shaqada NETWORKDAYS ee Microsoft Excel .

Habka koowaad waa inaad gujiso badhanka fx ee korka warqadda shaqada ee Excel.

Sanduuqa wada hadalka Gelida^{(Insert Function)} ayaa soo bixi doona.

Qaybta Dooro Qaybta^{(Select a Category)} , dhagsii Taariikhda iyo Waqtiga^{(Date and Time)} .

Qaybta Dooro shaqo^{(Select a Function)} , dhagsii SHABADAHA MAALMAHA LIISKA^{(NETWORKDAYS)} .

Kadib, dhagsii OK .

Sanduuqa wada hadalka doodaha Shaqada^{(Function Arguments)} ayaa soo bixi doona.

• Qaybta Start_date , geli A2 sanduuqa soo galinta.
• Qaybta Dhamaadka_date^(End_date) , geli B2 sanduuqa soo galinta.

Kadib, dhagsii OK .

Habka labaad waa in la gujiyo tabka Formulas oo aad gujiso ^(Formulas)taariikhda iyo wakhtiga^{(Date and Time )} badhanka ee kooxda Laybareeriga Function^{(Function Library )} .

Liiska hoos-u-dhaca, dooro SHABADAHA MAALMAHA^{(NETWORKDAYS)} .

Sanduuqa wada hadalka doodaha Shaqada^{(Function Arguments)} ayaa furmi doona.

Raac^(Follow) habka koowaad si aad u aragto habka.

Kadib dhagsii OK .

Waxaan rajeyneynaa in casharkaan uu kaa caawiyo inaad fahamto sida loo isticmaalo shaqada NETWORKDAYS gudaha Excel .

Akhri soo socda^{(Read next)} : Sida loo tiriyo erayada Microsoft Excel^{(How to count words in Microsoft Excel)} .

How to use NETWORKDAYS function in Excel

The NETWORKDAYS function in Microsoft Excel is a date and time function that returns the number of whole working days between Start_date and End_date. The NETWORKDAYS function excludes weekends (Saturday and Sunday) and dates identified in holiday. If the argument is not valid, the NETWORKDAYS function will return the error value #VALUE.

The formula for the NETWORKDAYS function is NETWORKDAYS(start_date,end_date,[holiday]).

The Syntax for NETWORKDAYS is:

• Start_date: The date that represents the start date. It is required.
• End_date: The date that represents the start date. It is required.
• Holidays: Dates that are excluded from the working days on the calendar. The list can be a range of cells containing the dates or a  serial number representing the date. It is optional.

How to use NETWORKDAYS function in Excel

Open Excel.

Create a table or open an existing table.

In his tutorial, we want to find the number of workdays between the start date and end date.

In the cell where you want to place the result type:

=NETWORKDAYS(A2, B2)

• A2 is the Start_date.
• B2 is the End_date.

Press Enter on the Keyboard to see the result and drag the fill handle down to see the other result in the table.

We want to find the number of workdays between the start date and end date with the holiday as non-working days.

In the cell where you want to place the result type:

=NETWORKDAYS(A2, B2, H2 )

H2 is the Holiday as a non-working day; it is optional.

Then press the Enter key to see the result.

There two other methods to use the NETWORKDAYS function in Microsoft Excel.

Method one is to click the fx button on top of the excel worksheet.

A Insert Function dialog box will pop up.

In the Select a Category section, click Date and Time.

In the section Select a Function, click NETWORKDAYS from the list.

Then, click OK.

A Function Arguments dialog box will appear.

• In the section Start_date, enter the A2 in the entry box.
• In the section End_date, enter the B2 in the entry box.

Then, click OK.

Method Two is to click the Formulas tab and click the Date and Time button in the Function Library group.

In the drop-down list, select NETWORKDAYS.

A Function Arguments dialog box will open.

Follow method one to see the procedure.

Then click OK.

We hope this tutorial helps you understand how to use the NETWORKDAYS function in Excel.

Read next: How to count words in Microsoft Excel.

Related posts

• Sida loo isticmaalo Percentile.Exc function gudaha Excel

• Sida loo tiriyo lambarka Haa ama Maya ee Excel

• Excel, Word ama PowerPoint ma bilaabi karaan markii ugu dambeysay

• Sida loo isticmaalo sifada Nooca Xogta tooska ah ee Excel

• Sida loo abuuro Shaxda Radar gudaha Windows 11/10

• Sida loo isticmaalo shaqada ISODD ee Excel

• Sida loo beddelo qaabka faylka caadiga ah ee lagu kaydiyo Word, Excel, PowerPoint

• Sida loo qoro, loo dhiso, loona isticmaalo shaqada VLOOKUP gudaha Excel

• Sida loo isticmaalo shaqada COOSE ee Excel

• Microsoft Excel waxay sababtaa isticmaalka CPU sare marka uu socdo Windows 10

• Sida loo beddelo midabka warqadda shaqada ee Excel

• Sida loo bilaabo Word, Excel, PowerPoint, Outlook in Mode Safe

• Sida loo tiriyo qiyamka nuqul ka mid ah tiirka Excel

• Sida loo abuuro Bracket tartanka gudaha Windows 11/10

• Sida loo qaboojiyo oo loo kala qaybiyo xaashida shaqada ee Excel

• Microsoft Excel waxay isku dayaysaa inay soo ceshato macluumaadkaaga

• Sida loo geliyo oo loo xisaabiyo foomamka iyo shaqooyinka Excel

• Sida loo isticmaalo INT iyo Functions LCM gudaha Excel

• Sida looga soo saaro magacyada domain URL-yada Microsoft Excel

• Sida loo qaybiyo hal tiir oo loo kala qaybiyo tiirar badan oo Excel ah