Yi amfani da Kwanan Wata a Kayan Shafin Ayyuka a Excel

Yadda za a yi aiki tare da kwanakin a Excel

Aikin yau za a iya amfani da ƙara kwanan wata zuwa aikin aiki (kamar yadda aka nuna a jere biyu daga cikin hoton da ke sama) da kuma lissafin kwanan wata (aka nuna a layuka uku zuwa bakwai sama).

Ayyukan, duk da haka, yana ɗaya daga cikin ayyuka mara kyau na Excel wanda ke nufin cewa yawancin lokaci yana ɗaukaka kansa a duk lokacin da aikin ɗawainiya ya ƙunshi aikin.

Yawanci, ɗawainiyar rubutu suna sake rikicewa a duk lokacin da aka buɗe su a kowace rana cewa aikin aiki ya bude kwanan wata zai canza sai dai an kashe na'urar ta atomatik.

Don hana yin gyare-gyaren kwanan wata a duk lokacin da aka aiwatar da takardar aiki ta amfani da rikodin atomatik, gwada ta amfani da wannan gajeren hanya na keyboard don shigar da kwanan wata a maimakon.

Yau Ayyukan Magana da Tambaya a yau

Haɗin aikin aiki yana nufin layout na aikin kuma ya haɗa da sunan aiki, shafuka, rabuɗɗun takaddama, da muhawara .

Hadawa don aikin yau shine:

= Yau ()

Ayyukan ba su da wata hujja da za a iya saitawa da hannu.

TODAY yana amfani da kwanan watan mai amfani da kwamfuta - wanda ya adana kwanan wata da lokaci a matsayin lambobi - a matsayin hujja. Ya sami wannan bayani game da kwanan wata ta hanyar karanta agogon kwamfutar.

Shigar da Kwanan Kwanan Kwanan Da Kayan aikin yau

Zaɓuɓɓuka don shigar da aikin TODAY sun haɗa da:

1. Rubuta cikakken aikin: = YANAYA () a cikin sashin layi na aiki
2. Shigar da aikin ta amfani da akwatin maganganun TODAY

Tun da aikin TODAY ba shi da wata hujja da za a iya shigar da hannu, mutane da yawa sun shiga aikin kawai maimakon amfani da akwatin maganganu.

Idan Kwanan Wata Yayi Ba Ana Ɗaukakawa ba

Kamar yadda aka ambata, idan aikin TODAY baya sabuntawa zuwa kwanan wata a duk lokacin da aka bude aikin aiki, to akwai yiwuwar an sauke rikodin rikodin aikin littafin.

Don kunna rikicewa na atomatik:

1. Danna kan fayil na rubutun don bude menu na fayil.
2. Danna Zaɓuɓɓuka a cikin menu don buɗe akwatin maganganu na Excel Zabuka.
3. Danna kan zaɓi na Formulas a cikin hagu na hagu domin duba samfuran da aka samo a cikin hannun dama na dakin maganganu.
4. A karkashin Ƙaƙwalwar Ayyukan Ɗa'afi na sashe, danna kan atomatik don kunna rikici ta atomatik.
5. Danna Ya yi don rufe akwatin maganganu kuma komawa zuwa aikin aiki.

Amfani da yau a Kidayar Kwanan wata

Amfani na yau da kullum na aiki ya bayyana lokacin da aka yi amfani dashi a lissafin kwanan wata - sau da yawa tare da wasu ayyukan kwanakin Excel - kamar yadda aka nuna a layuka uku zuwa biyar a cikin hoton da ke sama.

Misalai a cikin layuka uku zuwa biyar cire bayanin da ya danganci kwanan wata - irin su shekara, watan, ko rana ta yanzu - ta amfani da fitar da aikin yau a cikin A2 a matsayin ƙwaƙwalwar don ayyukan YEAR, MONTH, da DAY.

Za a iya amfani da aikin TODAY don lissafin lokaci tsakanin kwana biyu, kamar yawan kwanakin ko shekaru kamar yadda aka nuna a layuka shida da bakwai a cikin hoton da ke sama.

Dates a matsayin Lambobi

Kwanan wata a cikin samfurori a cikin layuka shida da bakwai za'a iya rabu da juna saboda Excel yana ajiye kwanakin azaman lambobi, waɗanda aka tsara a matsayin kwanakin a cikin takardun aiki don ya sa su sauƙi don muyi amfani da fahimta.

Alal misali, ranar 9/23/2016 (Satumba 23, 2016) a cikin salula A2 yana da lamba na 42636 (yawan kwanaki tun daga Janairu 1, 1900) yayin Oktoba 15, 2015 yana da lamba na 42,292.

Sashin ƙaddamarwa a cikin cell A6 yana yin amfani da waɗannan lambobi don samun lambar kwanakin tsakanin kwanakin biyu:

42,636 - 42,292 = 344

A cikin tsari a cikin salula A6, ana amfani da aikin DATE na Excel don tabbatar da ranar 10/15/2015 an shigar da kuma adana shi azaman kwanan wata.

A cikin misali a cikin salula A7 yana amfani da aikin SHEKARA don cire shekara ta yanzu (2016) daga aiki na yau a cikin salula A2 sannan kuma an raba shi daga wannan shekarar 1999 don samun bambancin tsakanin shekaru biyu:

2016 - 1999 = 16

Ƙaddamar da Bayanai Tsarin Hoto

Lokacin da aka cire kwanakin biyu a Excel, ana nuna sakamakon a matsayin kwanan wata maimakon yawan.

Wannan yana faruwa idan tantanin halitta dauke da tsari ya tsara kamar Janar kafin a shigar da tsari. Saboda ƙayyadadden ya ƙunshi kwanakin, Excel yana canja tsarin tantanin halitta zuwa kwanan wata.

Don duba sakamakon da aka yi a matsayin lambar, dole ne a sake tsara tsarin sirrin zuwa Janar ko zuwa Lambar.

Don yin wannan:

1. Bayyana tantanin halitta (s) tare da tsarawar ba daidai ba.
2. Danna-dama tare da linzamin kwamfuta don buɗe menu mahallin.
3. A cikin menu, zaɓi Tsarin Siffofin don buɗe akwatin maganganun Siffofin Siffar.
4. A cikin akwatin maganganu, danna kan Lambar shafin idan ya cancanta don nuna jerin zaɓin Tsarin.
5. A ƙarƙashin Sashin Siyiga, danna kan Janar.
6. Danna Ya yi don rufe akwatin maganganu kuma komawa zuwa aikin aiki.
7. Ya kamata a nuna sakamakon da aka yi a matsayin lambobi.