Verenga vhiki nemazuva ekushanda muExcel

• ZUVA basa
• Basa ZVAKANAKA
• BASA rebasa

Muchidzidzo ichi, iwe uchadzidza nzira yekuwana zuva revhiki kubva pazuva muExcel uye maverengero ehuwandu hwemazuva evhiki / ekushanda pakati pemazuva maviri.

ZUVA basa

1. basa ZUVA (WEEKDAY) muExcel inodzosa nhamba pakati pe1 (Svondo) na7 (Mugovera) inomiririra nhamba yezuva revhiki. Zvinotaridza kuti Zvita 16, 2013 mune fomula iri pazasi inowira neMuvhuro.

   =WEEKDAY(A1)

   =ДЕНЬНЕД(A1)

2. Iwe unogona zvakare kushandisa basa racho kuratidza zuva revhiki TEXT (TEKSTO).

   =TEXT(A1,"dddd")

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

   

3. Gadzira chimiro chemazuva echinyakare (dddd) kuratidza zita rezuva revhiki.

   

Basa ZVAKANAKA

1. basa VABATI VACHENA (NETWORKDAYS) inodzosa nhamba yemazuva evhiki (kunze kwekupera kwevhiki) pakati pemazuva maviri.

   =NETWORKDAYS(A1,B1)

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

   

2. Kana iwe ukatsanangura rondedzero yezororo, ipapo basa VABATI VACHENA (NETWORKDAYS) ichadzorera nhamba yemazuva ekushanda (kusingabatanidzi kupera kwevhiki nezororo) pakati pemazuva maviri.

   =NETWORKDAYS(A1,B1,E1:E2)

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

   

   Iyo kalendari iri pasi ichakubatsira iwe kunzwisisa zviri nani basa racho VABATI VACHENA (NETWORKDAYS).

   

3. Excel inochengeta misi senhamba uye inoverenga nhamba yemazuva kubva muna Ndira 0, 1900. Panzvimbo pekutsiva mutsara wemaseru mufomula, tsiva nhamba isingachinjiki inomiririra mazuva iwayo. Kuti uite izvi, sarudza E1:E2 mune fomula iri pazasi uye tinya F9.

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

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

   

BASA rebasa

1. basa ZUVA REBASA (ZUVA REBASA) rinenge rinopesana nemabasa VABATI VACHENA (NETWORKDAYS). Inodzosa zuva risati rasvika kana mushure mehuwandu hwakatarwa hwemazuva evhiki (kupera kwevhiki kusina).

   =WORKDAY(A1,B1)

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

   

Cherechedza: basa ZUVA REBASA (ZUVA REBASA) inodzosa nhamba yesiriri yezuva racho. Isa fomati yemazuva kusero kuti uiratidze.

Iyo kalendari iri pasi ichakubatsira iwe kunzwisisa zviri nani basa racho ZUVA REBASA (ZUVA REBASA).

Zvakare, kana iwe ukatsiva runyorwa rwemazororo, basa racho ZUVA REBASA (ZUVA REBASA) richadzosa zuva risati rasvika kana mushure mehuwandu hwakatarwa hwemazuva ekushanda (kunze kwekupera kwevhiki nezororo).