Daya daga cikin abubuwan ban sha'awa na Microsoft Excel shine RANAR yau. Yin amfani da wannan afareta, ana shiga kwanan wata a cikin tantanin halitta. Amma kuma za'a iya amfani dashi tare da wasu dabarun a hade. Yi la'akari da manyan abubuwan aikin RANAR yau, kamfani na aikinsa da hulɗa tare da sauran masu gudanar da aiki.
Amfani da Operator TODAY
Aiki RANAR yau yana fitar da fitarwa zuwa ƙayyadadden ƙwayar kwanan wata da aka sanya a cikin kwamfutar. Ya kasance ga rukuni na masu aiki "Kwanan wata da lokaci".
Amma kuna buƙatar fahimtar cewa wannan dabara kadai bazai sabunta ƙimar da ke cikin tantanin halitta ba. Wato, idan kun bude shirin a cikin 'yan kwanaki kuma ba ku kirguro dabarun da ke ciki ba (da hannu ko ta atomatik), to za a saita rana ɗaya a cikin tantanin, amma ba na yanzu ba.
Don bincika ko an saita lissafin atomatik a cikin takamaiman takaddar, kuna buƙatar aiwatar da jerin ayyukan madogara.
- Kasancewa a cikin shafin Fayilolije maki "Zaɓuɓɓuka" a gefen hagu na taga.
- Bayan an kunna sigogi taga, je zuwa sashin Tsarin tsari. Muna buƙatar toshe maɗaukakan saitunan Lissafin Lissafi. Ya sauya siga "Lissafi a cikin littafin" ya kamata a saita zuwa "Kai tsaye". Idan yana cikin wani yanayi na daban, to ya kamata a sanya shi kamar yadda aka bayyana a sama. Bayan an canza saitunan, danna maballin "Ok".
Yanzu, tare da kowane canji a cikin takaddar, za a sake karanta ta atomatik.
Idan saboda wasu dalilai baku son saita lissafin atomatik ba, to don sabunta abubuwan cikin tantanin halitta wanda ya kunshi aikin don kwanan wata RANAR yau, kuna buƙatar zaɓar shi, sanya siginan kwamfuta a cikin layin dabara kuma danna maɓallin Shigar.
A wannan yanayin, idan an kashe karatun atomatik, za'a yi shi kawai dangane da wannan kwayar, kuma ba a duk takaddar ba.
Hanyar 1: gabatar da aikin da hannu
Wannan mai aiki bashi da hujja. Harshen sa na da sauqi kuma yana kama da haka:
= TARBAYA ()
- Don amfani da wannan aikin, a sauƙaƙe saka wannan magana a cikin tantanin da kake son ganin hoto na kwanan wata.
- Don yin lissafi da nuna sakamakon akan allon, danna maballin Shigar.
Darasi: Sakamakon kwanan wata da ayyukan lokaci
Hanyar 2: yi amfani da Mayen aikin
Bugu da kari, zaka iya amfani Mayan fasalin. Wannan zabin ya dace sosai ga masu amfani da novel na Excel wadanda har yanzu suke rikice-rikice a cikin sunayen ayyuka da yadda ake daidaita su, kodayake a wannan yanayin yana da sauki kamar yadda zai yiwu.
- Zaɓi wayar akan takarda wanda za'a nuna kwanan wata. Danna alamar "Saka aikin"wanda yake a mashaya dabara.
- Mai kunnawa Aiki yana farawa. A cikin rukuni "Kwanan wata da lokaci" ko "Cikakken jerin haruffa" neman kashi "TODAY". Zaɓi shi kuma danna maballin. "Ok" a kasan taga.
- Smallan ƙaramin bayani buɗe bayani, wanda ke ba da rahoto game da dalilin wannan aikin, har ila yau ya ce ba shi da gardama. Latsa maballin "Ok".
- Bayan wannan, ranar da aka sanya a yanzu a kwamfutar mai amfani za a nuna shi a cikin tantanin da aka ƙayyade.
Darasi: Wizard ɗin Aiki a cikin Excel
Hanyar 3: canza tsarin tantanin halitta
Idan kafin shiga aikin RANAR yau tantanin yana da tsari na gama gari, za'a sake shi ta atomatik zuwa tsarin kwanan wata. Amma, idan an tsara kewayon don ƙimar daban, to ba zai canza ba, wanda ke nufin cewa ƙirar za ta samar da sakamakon da ba daidai ba.
Don ganin darajar nau'in kwayar mutum ko yanki a kan takardar, kuna buƙatar zaɓar kewayon da ake so kuma, a cikin "Gidan" shafin, kalli menene ƙimar da aka saita a cikin tsararren tsari na musamman akan kintinkiri a cikin toshe kayan aiki "Lambar".
Idan bayan shigar da dabara RANAR yau ba a saita tsarin ta atomatik ba a cikin tantanin halitta Kwanan Wata, to, aikin ba zai nuna sakamakon daidai ba. A wannan yanayin, dole ne a canza tsari da hannu.
- Danna-dama akan salula wacce kake son canja tsari. A menu wanda ya bayyana, zaɓi matsayi Tsarin Cell.
- Tsarin tsarawa yana buɗe. Je zuwa shafin "Lambar" idan an buɗe shi a wani wuri. A toshe "Lambobin adadi" zaɓi abu Kwanan Wata kuma danna maballin "Ok".
- Yanzu an tsara tantanin daidai kuma yana nuna kwanan wata.
Bugu da kari, a cikin taga tsara, Hakanan zaka iya canza gabatar da ranar yau. Tsarin tsoffin don samfuri "dd.mm.yyyy". Haskaka zaɓuɓɓuka daban-daban don ƙimomin a fagen "Nau'in", wanda yake a gefen dama na taga shirya, zaka iya canja bayyanar ranar nunawa a cikin tantanin halitta. Bayan canje-canje kar ka manta ka latsa maɓallin "Ok".
Hanyar 4: amfani da TODAY a hade tare da sauran dabaru
Hakanan aiki RANAR yau za a iya amfani da shi azaman sashin haɗaɗɗun tsari. A cikin wannan ingancin, wannan mai ba da izini zai ba ku damar magance matsaloli masu yawa fiye da amfani da 'yanci.
Mai aiki RANAR yau Zai dace sosai don amfani da ƙididdige lokutan lokaci, alal misali, lokacin da yake nuna shekarun mutum. Don yin wannan, muna rubuta wannan nau'in a cikin tantanin halitta:
= SHEKARA (TODAY ()) - 1965
Don amfani da dabara, danna kan maɓallin Shiga.
Yanzu, a cikin tantanin halitta tare da madaidaitan saiti don tattara bayanan takardu, shekarun rayuwar mutumin da aka haife shi a shekarar 1965 koyaushe za'a nuna shi. Ana iya amfani da irin wannan magana ga kowane shekarar haihuwa ko don kirga ranar tunawa da abin da ya faru.
Hakanan akwai wani tsari wanda ke nuna kyawawan abubuwa kwanaki da dama a cikin tantanin halitta. Misali, don nuna kwanan wata bayan kwana uku, zai yi kama da haka:
= RANAR () + 3
Idan kana buƙatar tunawa da kwanan wata kwana uku da suka gabata, to, dabarar zata yi kama da haka:
= RANAR () - 3
Idan kana son nunawa a cikin tantanin kawai yawan kwanan wata a watan, kuma ba kwanan wata gabaɗaya, to ana amfani da wannan kalmar:
= RANAR (TODAY ())
Irin wannan aiki don nuna lambar watan na yanzu zai yi kama da wannan:
= MATA (TODAY ())
Wannan shine, a watan Fabrairu lambar 2 zata kasance a cikin tantanin halitta, a cikin Maris - 3, da sauransu.
Ta amfani da tsari mai rikitarwa, zaku iya lissafin kwanaki nawa zasu wuce daga yau zuwa takamaiman kwanan wata. Idan ka tsara yadda za'a tsara su daidai, to ta wannan hanyar zaka iya ƙirƙirar timer na lissafin ma'aunin kwanan wata zuwa kwanan wata da aka bayar. Tsarin samfurin da yake da irin wannan damar shine kamar haka:
= DATEVALUE ("set_date") - TODAY ()
Madadin darajar "Sanya kwanan wata" Sanya takamaiman kwanan wata a tsarin "dd.mm.yyyy", wanda kuke buƙatar tsara ƙididdigewa.
Tabbatar cewa za'a tsara tantanin da acikin wannan lissafin za'a nuna shi don babban tsarin, in ba haka ba nunin sakamakon zai zama ba daidai bane.
Akwai yuwuwar haɗuwa tare da sauran ayyukan Excel.
Kamar yadda kake gani, amfani da aikin RANAR yau Ba za ku iya nuna kawai kwanan wata na yau ba, amma kuma ku ƙididdige sauran lissafi da yawa. Ilimin asalin yanayin wannan da sauran dabarun zai taimaka wajen kawo tsarin hada hadar wannan ma'aikaci. Idan ka tsara yadda yakamata a sake tsarin aikin a cikin takaddar, za a sabunta ƙimar ta atomatik.
