Thutong ena, u tla ithuta ho fumana letsatsi la beke ho tloha ho Excel le ho bala palo ea matsatsi a beke/ho sebetsa lipakeng tsa matsatsi a mabeli.
Mosebetsi oa LETSATSI
- mosebetsi LETSATSI (WEEKDAY) ho Excel e khutlisa nomoro lipakeng tsa 1 (Sontaha) le 7 (Moqebelo) e emelang palo ea letsatsi la beke. Ho bonahala eka la 16 Tšitoe, 2013 ka foromo e ka tlase e oela ka Mantaha.
=WEEKDAY(A1)
=ДЕНЬНЕД(A1)
- U ka sebelisa ts'ebetso ho bonts'a letsatsi la beke TEXT (TEMANA).
=TEXT(A1,"dddd")
=ТЕКСТ(A1;"дддд")
- Theha mokhoa o tloaelehileng oa letsatsi (dddd) ho hlahisa lebitso la letsatsi la beke.
Mosebetsi HLAKOLA
- mosebetsi MOSEBETSI HLOKO (NETWORKDAYS) e khutlisa palo ea matsatsi a beke (ho sa kenyeletsoe mafelo-beke) pakeng tsa matsatsi a mabeli.
=NETWORKDAYS(A1,B1)
=ЧИСТРАБДНИ(A1;B1)
- Haeba u bolela lethathamo la matsatsi a phomolo, joale mosebetsi MOSEBETSI HLOKO (NETWORKDAYS) e tla khutlisa palo ea matsatsi a mosebetsi (ho sa kenyeletsoe mafelo-beke le matsatsi a phomolo) pakeng tsa matsatsi a mabeli.
=NETWORKDAYS(A1,B1,E1:E2)
=ЧИСТРАБДНИ(A1;B1;E1:E2)
Khalendara e ka tlase e tla u thusa ho utloisisa mosebetsi hantle MOSEBETSI HLOKO (MATSATSI A MANTSOE).
- Excel e boloka matsatsi e le linomoro 'me e bala palo ea matsatsi ho tloha ka la 0 Pherekhong, 1900. Ho e-na le ho kenya letoto la lisele sebakeng sa foromo, fetola linomoro tse sa fetoheng tse emelang matsatsi ao. Ho etsa sena, khetha E1:E2 ka foromo e ka tlase ebe o tobetsa F9.
=NETWORKDAYS(A1,B1,{41633;41634})
=ЧИСТРАБДНИ(A1;B1;{41633;41634})
MOSEBETSI OA MOSEBETSI
- mosebetsi MOSEBETSI (LETSATSI LA MOSEBETSI) mesebetsi e batlang e fapane MOSEBETSI HLOKO (MATSATSI A MANTSOE). E khutlisetsa letsatsi pele kapa ka mor'a palo e boletsoeng ea matsatsi a beke (mafelo-beke ha a kenyelelitsoe).
=WORKDAY(A1,B1)
=РАБДЕНЬ(A1;B1)
Hlokomela: mosebetsi MOSEBETSI (TSATSATSI LA MOSEBETSI) e khutlisa nomoro ea seriale ea letsatsi. Kenya sebopeho sa letsatsi seleng ho e hlahisa.
Khalendara e ka tlase e tla u thusa ho utloisisa mosebetsi hantle MOSEBETSI (LETSATSI LA MOSEBETSI).
Hape, haeba u fetola lethathamo la matsatsi a phomolo, mosebetsi MOSEBETSI (LETSATSI LA MOSEBETSI) e tla khutlisa letsatsi pele kapa ka mor'a palo e boletsoeng ea matsatsi a ho sebetsa (ho sa kenyeletsoe mafelo-beke le matsatsi a phomolo).