Bala izinsuku zeviki nezinsuku zokusebenza ku-Excel

• DAY umsebenzi
• Umsebenzi CLEAR
• Umsebenzi WOSUKU LOMSEBENZI

Kulesi sifundo, uzofunda ukuthi ungaluthola kanjani usuku lwesonto osukwini lwe-Excel nokuthi ubalwa kanjani inani lezinsuku zeviki/izinsuku zokusebenza phakathi kwezinsuku ezimbili.

DAY umsebenzi

1. Umsebenzi DAY (USUKU LWEVIKI) ku-Excel ibuyisela inombolo ephakathi kuka-1 (ngeSonto) no-7 (uMgqibelo) emele inombolo yosuku lweviki. Kubonakala sengathi u-December 16, 2013 kufomula engezansi uwela uMsombuluko.

   =WEEKDAY(A1)

   =ДЕНЬНЕД(A1)

2. Ungasebenzisa futhi umsebenzi ukubonisa usuku lwesonto TEXT (UMBHALO).

   =TEXT(A1,"dddd")

   =ТЕКСТ(A1;"дддд")

   

3. Dala ifomethi yedethi yangokwezifiso (dddd) ukuze ubonise igama losuku lweviki.

   

Umsebenzi CLEAR

1. Umsebenzi ABASEBENZI ABAHLANZEKILE (NETWORKDAYS) ibuyisela inombolo yezinsuku zeviki (ngaphandle kwezimpelasonto) phakathi kwamadethi amabili.

   =NETWORKDAYS(A1,B1)

   =ЧИСТРАБДНИ(A1;B1)

   

2. Uma ucacise uhlu amaholide ke umsebenzi ABASEBENZI ABAHLANZEKILE (IZINSUKU ZOKUSEBENZA) zizobuyisela inombolo yezinsuku zokusebenza (ngaphandle kwezimpelasonto namaholide) phakathi kwamadethi amabili.

   =NETWORKDAYS(A1,B1,E1:E2)

   =ЧИСТРАБДНИ(A1;B1;E1:E2)

   

   Ikhalenda elingezansi lizokusiza ukuthi uqonde kangcono umsebenzi ABASEBENZI ABAHLANZEKILE (NETWORKDAYS).

   

3. I-Excel igcina amadethi njengezinombolo futhi ibala inani lezinsuku kusukela ngo-January 0, 1900. Esikhundleni sokushintsha uhla lwamaseli kufomula, shintsha izinombolo ezingaguquki ezimelela lezo zinsuku. Ukuze wenze lokhu, khetha E1:E2 kufomula engezansi bese uchofoza F9.

   =NETWORKDAYS(A1,B1,{41633;41634})

   =ЧИСТРАБДНИ(A1;B1;{41633;41634})

   

Umsebenzi WOSUKU LOMSEBENZI

1. Umsebenzi USUKU LOMSEBENZI (USUKU LOMSEBENZI) cishe imisebenzi ephambene ABASEBENZI ABAHLANZEKILE (NETWORKDAYS). Ibuyisela idethi engaphambi noma ngemva kwenombolo eshiwo yezinsuku zeviki (izimpelaviki azifakiwe).

   =WORKDAY(A1,B1)

   =РАБДЕНЬ(A1;B1)

   

Qaphela: Umsebenzi USUKU LOMSEBENZI (USUKULOMSEBENZI) lubuyisela inombolo ye-serial yedethi. Faka ifomethi yedethi kuseli ukuze uyibonise.

Ikhalenda elingezansi lizokusiza ukuthi uqonde kangcono umsebenzi USUKU LOMSEBENZI (USUKU LOMSEBENZI).

Futhi, uma ushintsha uhlu lwamaholide, umsebenzi USUKU LOMSEBENZI (USUKU LOMSEBENZI) luzobuyisela idethi engaphambi noma ngemva kwenombolo eshiwo yezinsuku zokusebenza (ngaphandle kwezimpelasonto namaholide).