Ayyukan Fasahar Excel

01 na 01

Ƙara / Ƙaddara watanni zuwa Dates

Yin amfani da aikin EDATE don Ƙara da ƙaddara watanni zuwa kwanan wata. © Ted Faransanci

Siffar Lissafin Jigogi

Ayyukan EDEL ta Excel za a iya amfani da su don ƙarawa ko rage musu watanni zuwa kwanakin da aka sani - irin su balaga ko kwanakin lokacin zuba jari ko kwanakin farko ko kwanakin ƙarshe.

Tun da aikin kawai ya ƙara ko kuma ya ƙayyade kowane watanni zuwa kwanan wata, sakamakon zai sauko kowace rana a wannan rana a matsayin ranar farawa.

Lissafin Jirgin

Bayanan da aka dawo ta aikin EDATE shine lambar serial ko kwanan wata. Aiwatar da tsarin kwanan wata zuwa kwayoyin da ke dauke da aikin EDATE domin nuna kwanakin kwanakin a cikin takardun aiki - da aka tsara a kasa.

Ƙungiyar Ayyuka na EDATE da Magana

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

Haɗin aikin aikin EDATE shine:

= EDATE (Start_date, Watanni)

Fara_date - (da ake buƙatar) kwanan wata na aikin ko lokaci a cikin tambaya

Watanni - (da ake bukata) - yawan watanni kafin ko bayan Fara_date

#VALUE! Kuskuren kuskure

Idan hujjar Start_date ba wata rana mai aiki ba, aikin zai dawo da #VALUE! darajar kuskure - kamar yadda aka nuna a jere 4 a cikin hoto a sama, tun 2/30/2016 (Fabrairu 30, 2016) ba daidai ba ne

Ayyukan EDATE ta Excel misali

Kamar yadda aka nuna a cikin hoton da ke sama, wannan misali yana amfani da aikin EDATE don ƙarawa da kuma cire wasu adadin watanni zuwa ranar Janairu 1, 2016.

Bayanan da ke ƙasa ya rufe matakan da ake amfani dashi don shigar da aikin a cikin sel B3 da C3 na takardar aiki .

Shigar da aikin EDATE

Zaɓuɓɓukan don shigar da aikin da ƙididdigar sun hada da:

Kodayake yana yiwuwa a rubuta aikin gaba ɗaya ta hannu, mutane da yawa sun fi sauƙi don amfani da akwatin maganganu don shigar da muhawarar aiki.

Matakan da ke ƙasa ya rufe shigar da aikin EDATE da aka nuna a cikin sakon B3 a cikin hoton da ke sama ta amfani da akwatin maganganun aikin.

Tun da za a shigar da dabi'un da za a shiga don watanni watau (-6 da -12) kwanakin a cikin sel B3 da C3 zasu kasance a baya fiye da kwanan farawa.

Misali na EDATE - Sakamako na Watanni

  1. Danna kan tantanin halitta B3 - don sa shi tantanin halitta;
  2. Danna kan Rubutun hanyoyin shafin rubutun;
  3. Danna kwanan wata da ayyukan lokaci don buɗe jerin abubuwan da aka sauke aikin;
  4. Danna kan BABI a cikin jerin don kawo akwatin maganganu na aikin;
  5. Danna maɓallin Start_date a cikin akwatin maganganu;
  6. Danna kan A3 a cikin takardun aiki don shigar da wannan tantanin salula a cikin akwatin maganganun a matsayin shaida na Start_date ;
  7. Latsa maɓalli F4 a kan keyboard don yin A3 mai cikakkiyar tantancewa game da salula - $ A $ 3;
  8. Danna jerin kwanan watan a cikin akwatin maganganu;
  9. Danna sel B2 a cikin takardun aiki don shigar da wannan tantanin salula a cikin akwatin maganganu a matsayin Magana na watanni ;
  10. Danna Ya yi don kammala aikin kuma komawa cikin takardun aiki;
  11. Ranar 7/1/2015 (Yuli 1, 2015) - ya bayyana a tantanin halitta B3 wanda shine watanni shida kafin ranar farawa;
  12. Yi amfani da maɓallin cikawa don kwafe aikin EDATE zuwa cell C3 - ranar 1/1/2015 (Janairu 1, 2015) ya kamata ya bayyana a cell C3 wanda shine watanni 12 kafin ranar farawa;
  13. Idan ka danna kan tantanin C3 da cikakken aikin = EDATE ($ A $ 3, C2) ya bayyana a cikin maɓallin tsari a sama da takardun aiki;

Lura : Idan lamba, irin su 42186 , ya bayyana a cikin tantanin halitta B3 yana iya yiwuwa tantanin halitta yana da Tsarin Janar yana amfani da ita. Dubi umarnin da ke ƙasa domin canza canjin zuwa kwanan wata;

Canza kwanan wata a cikin Excel

Hanyar da sauri da sauƙi don canja tsarin kwanan wata don kwayoyin da ke dauke da aikin EDATE shine zaɓi ɗaya daga jerin jerin zaɓuɓɓukan tsarawa da aka tsara a cikin akwatin Siffofin Siffofin Siffofin. Matakan da ke ƙasa suna amfani da haɗin gajeren hanya na keyboard na Ctrl + 1 (lambar daya) don buɗe akwatin maganganun Siffofin Siffar.

Don canja zuwa tsarin kwanan wata:

  1. Gano sel a cikin takardun aiki wanda ya ƙunshi ko zai ƙunshi kwanakin
  2. Latsa maballin Ctrl + 1 don buɗe akwatin maganganun Siffofin Siffar
  3. Danna maɓallin Lamba a cikin akwatin maganganu
  4. Danna Kwanan wata a cikin jerin jigogi na Category (gefen hagu na akwatin maganganu)
  5. A cikin Maballin Nau'in (gefen dama), danna kan tsarin kwanan da ake so
  6. Idan ɗakunan da aka zaɓa sun ƙunshi bayanai, akwatin Sample zai nuna samfoti na tsarin da aka zaɓa
  7. Danna maɓallin OK don adana canjin yanayin kuma rufe akwatin maganganu

Ga wadanda suka fi so su yi amfani da linzamin kwamfuta maimakon keyboard, hanyar da za a buɗe don buɗe akwatin maganganu shine:

  1. Danna danna maɓallin da aka zaɓa don buɗe menu mahallin
  2. Zabi Siffofin Siffofin ... daga menu don buɗe akwatin maganganun Siffofin Siffar

###########

Idan, bayan canzawa zuwa tsarin kwanan wata don tantanin halitta, tantanin halitta yana nuna jeri na alamun hash, saboda tantanin halitta ba shi da isasshen isa don nuna bayanan da aka tsara. Hada tantanin halitta zai gyara matsalar.