E helu i nā lā pule a me nā lā hana ma Excel
  • hana LA
  • Hana MAHELE
  • hana WORKDAY

Ma kēia kumu aʻo, e aʻo ʻoe pehea e loaʻa ai ka lā o ka pule mai kahi lā ma Excel a pehea e helu ai i ka helu o nā lā pule/lā hana ma waena o nā lā ʻelua.

hana LA

  1. Launch LĀ (WEEKDAY) ma Excel e hoʻihoʻi i kahi helu ma waena o 1 (Sabati) a me 7 (Sabati) e hōʻike ana i ka helu o ka lā o ka pule. ʻIke ʻia e hāʻule ana ka lā 16 o Dekemaba, 2013 ma ka papa kuhikuhi ma lalo nei i ka Pōʻakahi.

    =WEEKDAY(A1)

    =ДЕНЬНЕД(A1)

  2. Hiki iā ʻoe ke hoʻohana i ka hana e hōʻike i ka lā o ka pule KAUA (TEXT).

    =TEXT(A1,"dddd")

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

    E helu i nā lā pule a me nā lā hana ma Excel

  3. E hana i kahi hōʻano lā maʻamau (dddd) e hōʻike i ka inoa o ka lā o ka pule.

    E helu i nā lā pule a me nā lā hana ma Excel

Hana MAHELE

  1. Launch NA HANA MAEMAE (NETWORKDAYS) e hoʻihoʻi i ka helu o nā lā pule (koe nā hopena pule) ma waena o nā lā ʻelua.

    =NETWORKDAYS(A1,B1)

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

    E helu i nā lā pule a me nā lā hana ma Excel

  2. Inā ʻoe e kuhikuhi i kahi papa inoa o nā lā hoʻomaha, a laila ka hana NA HANA MAEMAE (NETWORKDAYS) e hoʻihoʻi i ka helu o nā lā hana (koe nā hopena pule a me nā lā hoʻomaha) ma waena o nā lā ʻelua.

    =NETWORKDAYS(A1,B1,E1:E2)

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

    E helu i nā lā pule a me nā lā hana ma Excel

    E kōkua ka kalena ma lalo iā ʻoe e hoʻomaopopo maikaʻi i ka hana NA HANA MAEMAE (NEWORKDAYS).

    E helu i nā lā pule a me nā lā hana ma Excel

  3. Mālama ʻo Excel i nā lā ma ke ʻano he mau helu a helu i ka helu o nā lā mai Ianuali 0, 1900. Ma kahi o ka hoʻololi ʻana i kahi ʻano o nā cell i loko o ke ʻano, e hoʻololi i nā helu mau e hōʻike ana i kēlā mau lā. No ka hana ʻana i kēia, koho E1:E2 ma ka papa ma lalo a kaomi F9.

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

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

    E helu i nā lā pule a me nā lā hana ma Excel

hana WORKDAY

  1. Launch LA HANA (WORKDAY) kokoke i nā hana kū'ē NA HANA MAEMAE (NEWORKDAYS). Hoʻihoʻi ia i ka lā ma mua a i ʻole ma hope o ka helu i ʻōlelo ʻia o nā lā pule (ʻaʻole ʻia nā hopena pule).

    =WORKDAY(A1,B1)

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

    E helu i nā lā pule a me nā lā hana ma Excel

'Ōlelo Aʻo: Launch LA HANA (WORKDAY) hoʻihoʻi i ka helu serial o ka lā. E hoʻopili i kahi ʻano lā i ke kelepona e hōʻike ai.

E kōkua ka kalena ma lalo iā ʻoe e hoʻomaopopo maikaʻi i ka hana LA HANA (LALA HANA).

E helu i nā lā pule a me nā lā hana ma Excel

Eia hou, inā hoʻololi ʻoe i kahi papa inoa o nā lā hoʻomaha, ka hana LA HANA (WORKDAY) e hoʻihoʻi i ka lā ma mua a ma hope paha o ka helu o nā lā hana (koe nā hopena pule a me nā lā hoʻomaha).

Waiho i ka Reply