Ƙidaya kwanakin mako da kwanakin aiki a cikin Excel

• Aikin DAY
• Aiki CLEAR
• Aikin AIKI

A cikin wannan koyawa, za ku koyi yadda ake samun ranar mako daga kwanan wata a cikin Excel da yadda ake ƙidaya adadin kwanakin mako / kwanakin aiki tsakanin ranaku biyu.

Aikin DAY

1. aiki DAY (RANAR MAKO) a cikin Excel yana dawo da lamba tsakanin 1 (Lahadi) da 7 (Asabar) yana wakiltar adadin ranar mako. Ya bayyana cewa Disamba 16, 2013 a cikin dabaran da ke ƙasa ya faɗi a ranar Litinin.

   =WEEKDAY(A1)

   =ДЕНЬНЕД(A1)

2. Hakanan zaka iya amfani da aikin don nuna ranar mako rubutu (TEXT).

   =TEXT(A1,"dddd")

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

   

3. Ƙirƙiri tsarin kwanan wata na al'ada (dddd) don nuna sunan ranar mako.

   

Aiki CLEAR

1. aiki MA'AIKATA TSAFTA (NETWORKDAYS) yana mayar da adadin kwanakin mako (ban da karshen mako) tsakanin ranaku biyu.

   =NETWORKDAYS(A1,B1)

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

   

2. Idan ka ƙayyade jerin bukukuwan, to aikin MA'AIKATA TSAFTA (NETWORKDAYS) zai dawo da adadin kwanakin aiki (ban da karshen mako da hutu) tsakanin ranaku biyu.

   =NETWORKDAYS(A1,B1,E1:E2)

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

   

   Kalanda da ke ƙasa zai taimaka muku fahimtar aikin sosai MA'AIKATA TSAFTA (RANAR NETWORK).

   

3. Excel yana adana kwanakin a matsayin lambobi kuma yana ƙidaya adadin kwanakin tun daga Janairu 0, 1900. Maimakon musanya kewayon sel a cikin dabarar, maye gurbin adadin adadin da ke wakiltar waɗannan kwanakin. Don yin wannan, zaɓi E1: ku 2 a cikin dabarar da ke ƙasa kuma danna F9.

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

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

   

Aikin AIKI

1. aiki RANAR AIKI (RANAR AIKI) kusan ayyuka sabani MA'AIKATA TSAFTA (RANAR NETWORK). Yana mayar da kwanan watan kafin ko bayan ƙayyadadden adadin kwanakin mako (ban da ƙarshen mako).

   =WORKDAY(A1,B1)

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

   

lura: aiki RANAR AIKI (RANAR AIKI) yana mayar da lambar serial na kwanan wata. Aiwatar da tsarin kwanan wata zuwa tantanin halitta don nuna shi.

Kalanda da ke ƙasa zai taimaka muku fahimtar aikin sosai RANAR AIKI (RANAR AIKI).

Bugu da ƙari, idan kun maye gurbin jerin bukukuwan, aikin RANAR AIKI (RANAR AIKI) zai dawo da kwanan watan kafin ko bayan ƙayyadadden adadin kwanakin aiki (ban da ƙarshen mako da hutu).