Kafa ranar mako zuwa kwanan wata a Microsoft Excel

Lokacin aiki a cikin Excel, aikin yakan nuna wani lokacin cewa bayan shigar da takamaiman kwanan wata, ranar makon da ya dace da ita ana nuna shi a cikin tantanin halitta. A zahiri, don warware wannan matsalar ta hanyar irin wannan tebur mai ƙarfin aiki kamar Excel, watakila ta hanyoyi da yawa. Bari mu ga abin da zaɓuɓɓuka suka wanzu don yin wannan aikin.

Nunin ranar mako a cikin Excel

Akwai hanyoyi da yawa don nuna ranar makon ta hanyar kwanan watan da aka shigar, daga tsara sel zuwa aikace aikace. Bari muyi la'akari da duk zaɓuɓɓukan da ake dasu don yin aikin da aka ƙayyade a cikin Excel, saboda mai amfani zai iya zaɓar mafi kyawun yanayi don takamaiman yanayi.

Hanyar 1: tsara tsari

Da farko dai, bari mu ga yadda tsara sel suka baka damar nuna ranar sati ta hanyar kwanan watan da aka shigar. Wannan zaɓin ya haɗa da sauya kwanan wata zuwa ƙimar da aka ƙayyade, maimakon adana nuni na waɗannan nau'ikan bayanan a kan takardar.

1. Shigar da kowane kwanan wata mai ɗauke da bayanai akan lambar, wata da shekara, a cikin tantanin da ke kan allo.



2. Mun danna kan tantanin tare da maɓallin linzamin kwamfuta na dama. An ƙaddamar da menu na mahallin. Zabi wani matsayi a ciki "Tsarin kwayar halitta ...".



3. Tsarin tsarawa yana farawa. Matsa zuwa shafin "Lambar"idan ya bude a wasu shafin. Ci gaba a cikin siga toshe "Lambobin adadi" saita canzawa zuwa matsayi "Duk fayiloli". A fagen "Nau'in" da hannu shigar da darajar masu zuwa:

   DDDD

   Bayan haka, danna maɓallin "Ok" a kasan taga.



4. Kamar yadda kake gani, maimakon kwanan wata, an nuna cikakken sunan ranar sati mai dacewa da shi a cikin tantanin halitta. A lokaci guda, da aka zaɓi wannan tantanin, a cikin masarar dabara za ku ga nuni zuwa kwanan wata.

A fagen "Nau'in" tsara windows maimakon ƙima DDDD Hakanan zaka iya shigar da magana:

DDD

A wannan yanayin, takardar za ta nuna sunan gajartar ranar mako.

Darasi: Yadda za a canza tsarin tantanin halitta a cikin Excel

Hanyar 2: amfani da aikin TEXT

Amma hanyar da aka gabatar a sama ta ƙunshi juya kwanan wata zuwa ranar mako. Shin akwai zaɓi don waɗannan abubuwan biyu su nuna a takarda? Wato, idan muka shigar da kwanan wata a cikin sel guda, to ya kamata ranar mako ta bayyana a wani. Ee, irin wannan zaɓi akwai. Ana iya yin hakan ta amfani da dabara SAURARA. A wannan yanayin, ƙimar da muke buƙata za a nuna ta ƙayyadadden tantanin halitta a cikin tsarin rubutu.

1. Muna rubuta kwanan wata akan kowane ɓangaren takardar. Sannan zaɓi kowane ɓoyayyen tantanin halitta. Danna alamar. "Saka aikin"wanda yake kusa da layin tsari.



2. Tagan taga ya fara tashi. Wizards na Aiki. Je zuwa rukuni "Rubutu" kuma daga jerin masu aiki zaɓi sunan SAURARA.



3. Farashin muhawara na aiki zai bude SAURARA. An tsara wannan ma'aikacin don nuna ƙayyadadden lambar a cikin sigar rubutun da aka zaɓa. Ya na da Syntax mai zuwa:

   = LATSA (Darajar; Tsarin)

   A fagen "Darajar" muna buƙatar bayyana adireshin tantanin halitta wanda ya ƙunshi kwanan wata. Don yin wannan, sanya siginar siginan kwamfuta a cikin takamammen filin da hagu-danna kan wannan kwayar a cikin takardar. Adireshin yana nan da nan.

   A fagen "Tsarin" ya danganta da abin da muke son samun cikakken wakilci ko gajarta wakilcin ranar mako, muna gabatar da bayanin dddd ko ddd ba tare da ambato ba.

   Bayan shigar da wannan bayanan, danna maballin "Ok".



4. Kamar yadda muka gani a cikin tantanin da muka zaba a farkon, an nuna ƙayyadaddun ranar sati a tsarin rubutun da aka zaɓa. Yanzu a kan takaddunmu duka kwanan wata da ranar mako suna nunawa lokaci guda.

Haka kuma, idan ka canza darajar kwanan wata a kwayar, ranar sati zai canza ta atomatik gwargwado. Don haka, canza kwanan wata, zaku iya gano ranar da mako zai kasance.

Darasi: Mayan Maɗaukaki

Hanyar 3: amfani da aikin WEEKLY

Akwai kuma wani jami'in da zai iya nuna ranar makon ga wani kwanan wata. Wannan aiki ne. RANAR. Gaskiya ne, bai bayyana sunan ranar mako ba, amma lambar sa. Haka kuma, mai amfani na iya sanyawa daga wace rana (Lahadi ko Litinin) za a kirga lambar.

1. Zaɓi wayar don nuna ranar makon. Danna alamar "Saka aikin".



2. Tagan ya sake budewa Wizards na Aiki. Wannan lokacin mun koma ga rukuni "Kwanan wata da lokaci". Zaɓi suna RANAR kuma danna maballin "Ok".



3. Yana zuwa taga bayanan muhawara RANAR. Ya na da Syntax mai zuwa:

   = DAY (kwanan wata_ in_numeric_format; [type])

   A fagen "Kwanan wata a lamba shigar da takamaiman kwanan wata ko adireshin tantanin a kan takarda da yake ciki.

   A fagen "Nau'in" lamba daga 1 a da 3, wanda ke tantance yadda za a ƙidaya kwanakin mako. Lokacin saita lamba "1" Lambar za ta gudana ne daga ranar Lahadi, kuma za a sanya lambar sirri zuwa yau na mako "1". Lokacin saita darajar "2" Lambar za ta gudana ne daga Litinin. Wannan ranar sati za'a bashi lambar serial "1". Lokacin saita darajar "3" Lambobi kuma zasu gudana daga Litinin, amma a wannan yanayin, Litinin za a sanya lambar serial "0".

   Hujja "Nau'in" ba a buƙata. Amma, idan kun ƙetare shi, ana la'akari da cewa ƙimar gardamar daidai take da ita "1"watau mako yana farawa ranar Lahadi. Wannan al'ada ce a ƙasashen da ke magana da Turanci, amma wannan zaɓi bai dace da mu ba. Saboda haka a fagen "Nau'in" saita darajar "2".

   Bayan aiwatar da waɗannan matakan, danna kan maɓallin "Ok".



4. Kamar yadda kake gani, lambar farfajiyar ranar satin da ya dace da kwanan watan da aka shigar yana nunawa cikin tantanin da aka nuna. A cikin lamarinmu, wannan lambar "3"wanda tsaye ga matsakaici.

Kamar yadda yake a cikin aikin da ya gabata, lokacin canza kwanan wata, ranar sati a cikin satin da aka shigar da mai aiki ta atomatik.

Darasi: Sakamakon kwanan wata da ayyukan lokaci

Kamar yadda kake gani, a cikin Excel akwai manyan zaɓuɓɓuka guda uku don gabatar da kwanan wata a matsayin ranar mako. Dukkanin waɗannan suna da sauƙi kuma basa buƙatar mai amfani don samun ƙwarewar ƙwarewa. Ofayansu shine amfani da tsararren tsari, ɗayan kuma suna amfani da ayyukan ginannun don cimma waɗannan burin. Ganin cewa tsarin da hanyar nuna bayanai a cikin kowane yanayi da aka bayyana sun bambanta sosai, mai amfani dole ne ya zabi wanne daga cikin waɗannan zaɓuɓɓuka a cikin wani yanayin da ya fi dacewa da shi.