Ranar mako ta kwanan wata fice

Lokacin aiki a Forevice, wani lokaci ana tayar da aikin saboda haka bayan shigar da takamaiman kwanan wata a cikin sel, ranar mako, wanda ya dace da shi. Halitta, yana yiwuwa ya shirya wannan aiki ta hanyar irin wannan iko tebur processor a matsayin ɗan gudun hijira, yiwu a hanyoyi da dama. Bari mu ga wane zaɓuɓɓuka ake zaɓuɓɓuka don aiwatar da wannan aikin.

Nuna ranar sati a eccele

Akwai hanyoyi da yawa don nuna ranar sati don kwanakin da aka shigar, jere daga tsarawa da sel da ƙare tare da amfani da ayyuka. Bari mu bincika duk zaɓuɓɓukan da suke yanzu don aiwatar da ayyukanta da aka ƙayyade a cikin ECCELE don mai amfani zai iya zaɓan mafi kyawun su don takamaiman yanayin.

Hanyar 1: Tsarin aikace-aikacen

Da farko dai, bari mu ga yadda tsarin tantanin halitta za a iya nuna ranar sati don ranar da aka shigar. Wannan zabin yana haifar da jujjuyawar ranar da ƙayyadadden ƙayyadadden, kuma ba adana hotunan duka nau'ikan nau'ikan bayanan akan takardar.

1. Mun gabatar da kowane kwanan wata wanda ya ƙunshi bayanai akan lambar, wata da shekara, a cikin tantaninta a kan takardar.



2. Latsa wurin maɓallin linzamin kwamfuta na dama. An ƙaddamar da menu na mahallin. Mun zabi a ciki matsayin "tsarin sel ...".



3. An fara taga taga. Matsar cikin shafin "lamba" idan an buɗe wa wani shafin. Bayan haka, a cikin "adadi na lambobi" sigogi, da aka kunna zuwa "duk tsari" matsayi. A cikin "nau'in" filin shigar da wannan darajar:

   DDDDD

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



4. Kamar yadda kake gani, a cikin tantanin halitta maimakon ranar, cikakken sunan ranar sati ya dace. A lokaci guda, zaɓar wannan sel, a cikin dabara har yanzu za ku iya ganin nuni ranar.

A cikin filin "nau'in tsarin taga, maimakon ƙimar DDMD, Hakanan zaka iya shigar da furcin:

DDDDDUF

A wannan yanayin, jerin za su nuna sunayen da aka saukar na ranar mako.

Darasi: Yadda ake canza tsarin tantancewa

Hanyar 2: Yin Amfani da Rubutun Aiki

Amma hanyar da aka gabatar da su sama ta bayar da canji ranar a ranar mako. Shin akwai wani zaɓi don haka ana nuna duka waɗannan dabi'u a takardar? Wato, idan cikin sel guda za mu shigar da ranar, sannan ranar sati ya kamata a nuna. Ee, wannan zabin ya wanzu. Ana iya yin ta amfani da tsarin rubutu. A wannan yanayin, darajar da kuke buƙata za a nuna ta a cikin ƙayyadaddun tantanin halitta a tsarin rubutu.

1. Yi rikodin kwanan wata akan kowane bangare. Sannan zaɓi duk wani sel wood. Danna kan "saka aiki" gunkin "wato yana kusa da tsarin dabara.



2. Window ɗin Window taga yana farawa. Je zuwa rukuni "rubutu" kuma daga jerin masu aiki, zaɓi sunan "rubutu".



3. Text aikin muhawara taga yana buɗewa. Ana kiransa wannan mai amfani don fitarwa lambar da aka ƙayyade a cikin sigar da aka zaɓa da aka zaɓa na tsarin rubutu. Yana da syntax masu zuwa:

   = Rubutu (darajar; tsari)

   A cikin filin "darajar", muna buƙatar tantance adireshin kwayar da ke ɗauke da kwanan wata. Don yin wannan, saita sigin siginar zuwa filin da aka ƙayyade da maɓallin linzamin kwamfuta na hagu Latsa a kan wannan sel a kan takardar. Adireshin zai bayyana nan da nan.

   A cikin filin "Tsarin" dangane da abin da muke son samun cikakken ra'ayi game da ranar mako cike ko kuma ka gabatar da furcin "DDMD" ko "DDD" ba tare da kwatancen ba.

   Bayan shigar da wannan bayanan, danna maɓallin "Ok".



4. Kamar yadda muke gani a cikin tantanin halitta, wanda muka zaɓa a farkon, an nuna ƙirar ranar sati a cikin tsarin rubutu da aka zaɓa. Yanzu muna da kwanan wata a kan takardar da kuma ranar, da ranar mako a lokaci guda.

Haka kuma, idan cikin tantaninta don canza darajar kwanan wata, to, kamar yadda ta atomatik canza ranar mako. Don haka, canza ranar da zaku iya ganowa a wace rana ce makoma zai yi.

Darasi: Jagora na ayyuka a cikin excele

Hanyar 3: aikace-aikacen aikin yau

Akwai wani ma'aikaci wanda zai iya kawo ranar mako don ranar da aka bayar. Wannan aiki ne na rana. Gaskiya ne, tana nuna sunan ranar mako, amma lambarsa. A lokaci guda, za a iya shigar da mai amfani daga wace rana (daga Lahadi ko Litinin) za a ƙidaya lamba.

1. Muna nuna tantanin halitta don fitowar ranar mako. Danna kan "saka aiki" icon "icon".



2. Window Window taga ya buɗe. A wannan karon mun je rukuni na rukuni "kwanan wata da lokacin" lokaci ". Zabi sunan "nuna" kuma danna maɓallin "Ok".



3. Canjin zuwa muhawara na muhawara ta hujja. Yana da syntax masu zuwa:

   = Nuna (kwanan wata_other_format; [nau'in])

   A cikin "kwanan wata a cikin Quital Tsarin" filin, za mu shigar da takamaiman kwanan wata ko adireshin tantanin halitta a kan wanda yake ƙunshe.

   A filin "nau'in", an saita lamba daga 1 zuwa 3, wanda ke ƙayyade daidai yadda kwanakin ya yi. Lokacin shigar da lambar "1", yawan lokaci zai faru tun ranar Lahadi, kuma wannan ranar mako za a sanya lambar jerin "1". Lokacin shigar da darajar "2", za a yi lamba, farawa daga Litinin. Wannan ranar za a ba da lambar jerin "1". Lokacin shigar da darajar "3", lambar za ta faru daga Litinin, amma a wannan yanayin za a sanya ranar Litinin ɗin da aka tsara "0".

   "Nau'in" gardama ba wajibi ne. Amma, idan an tsallake shi, an yi imani da cewa ƙimar hujjar ita ce "1", wato, sati fara ranar Lahadi. Don haka yarda a ƙasashe Turanci-magana, amma wannan zaɓi bai dace da mu ba. Saboda haka, a cikin filin "nau'in", mun saita darajar "2".

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



4. Kamar yadda muke gani, lambar jerin sati na mako ana nuna shi a cikin tantanin halitta, wanda yayi daidai da kwanakin da aka shigar. A cikin lamarinmu, wannan shine lambar "3" wanda ke nufin Laraba.

Kamar yadda yake a aikin da ya gabata, ana canza ranar da ranar sati ta atomatik lokacin da aka canza ranar a cikin tantanin halitta wanda aka sanya.

Darasi: Kwanan wata da lokaci na lokaci a cikin excele

Kamar yadda kake gani, akwai manyan zaɓuɓɓuka guda uku don ranar mako a eccele. Dukkansu suna da sauki kuma ba sa buƙatar wasu takamaiman ƙwarewar da ke amfani. Ofayansu shine amfani da tsari na musamman, kuma wasu kuma suna amfani da ayyukan da aka yi amfani da su don cimma waɗannan dalilai. La'akari da cewa tsarin da kuma hanyar nuna bayanai a kowane bayanin da aka bayyana ya bambanta da yanayin da aka ƙayyade a cikin yanayin wani yanayi ya dace da duka.