Indlela yokusebenza nemini kwi-Excel
Umsebenzi we-TODAY ungasetyenziselwa ukongeza umhla okhoyo kwiphepha lokusebenzela (njengoko kuboniswe kumqolo ombini womfanekiso ongentla) kunye nokubala kwamanani (kuboniswe kwimigangatho emithathu ukuya kwi sixhenxe ngaphezulu).
Umsebenzi, nangona kunjalo, ngenye yezinto ze-Excel ezizenzekelayo ezithetha ukuba ngokuqhelekileyo ihlaziywa rhoqo xa ishidi lomsebenzi equkethe umsebenzi liphinde lenziwe.
Ngokuqhelekileyo, ama-worksheet aphinde ahlaziywe rhoqo xa evuliwe njalo yonke imihla ukuba iphepha lokusebenzela livuliwe umhla uya kutshintsha ngaphandle kokuba ukucima ngokuzenzekelayo kuphelile.
Ukuthintela ukuba utshintsho lomhla ngalunye xa iphepheni lokusebenzela usebenzisa ukulungiswa ngokuzenzekelayo, zama ukusebenzisa le ndlela yokunqumla ikhibhodi ukufaka umhla wangoku endaweni yoko.
NAMANYE I-Syntax yeeNtsebenzo kunye neeArguments
I- syntax yomsebenzi ibhekisela kwisakhiwo somsebenzi kwaye ibandakanya igama lomsebenzi, iibakaki, abahluli be-comma kunye neengxabano .
I-syntax yomsebenzi we-TODAY ngu:
= TODAY ()
Lo msebenzi awunazo iziphakamiso ezingasetwa ngesandla.
NAMUHLA isebenzisa usuku lwe-serial yecomputer - olugcina umhla kunye nexesha nje njengenombolo-njengengxabano. Ifumana le ngcaciso ngomhla okhoyo ngokufunda iwashi yekhompyutha.
Ukungena Umhla Wangoku Ngomhla
Izinketho zokwenza umsebenzi we-TODAY ziquka:
- Ukuthayipha umsebenzi opheleleyo: = TODAY () kwifayile yeshidi
- Ukufaka umsebenzi usebenzisa ibhokisi yencoko yababini ye -TODAY
Ekubeni umsebenzi we-TODAY awunayo nayiphi na ingxabano engangeniswa ngesandla, abaninzi abantu bafuna ukuthayipha nje umsebenzi ngaphandle kokusebenzisa ibhokisi yencoko.
Ukuba Usuku Lwangoku aluyi kuhlaziywa
Njengoko kuthethwe, ukuba umsebenzi we-TODAY awuyi kuhlaziywa kumhla okhoyo ngeli xesha ixesha lephepha lephepha livuliwe, mhlawumbi ukulungiswa ngokuzenzekelayo kwincwadi yokusebenzela ivaliwe.
Ukuqalisa ukulungiswa ngokuzenzekelayo:
- Cofa kwifayile yefayile yedbhoni ukuvula imenyu yefayile.
- Cofa kwiNketho kwimenyu ukuvula ibhokisi yencoko yebhokisi ye-Excel.
- Cofa kwi- Formulas inketho kwiwindow yesandla sokunxele ukujonga iinketho ezikhoyo kwiwindow yesokunene kwibhokisi yencoko.
- Ngaphantsi kweCandelo leeNcwadi zokukhetha zokuCwangcisa, nqakraza kwi- Automatic ukuvula ukulungiswa kokuzenzekelayo .
- Cofa OK ukuvala ibhokisi yencoko kwaye ubuyele kwiphepha lokusebenzela.
Ukusebenzisa i-TODAY kumhla wokubala
Umsebenzi wokwenene we-TODAY umsebenzi uyacaca xa kusetyenziswa kumanani omhla - ngokuqhelekileyo ngokubambisana neminye imisebenzi yosuku lwe-Excel - njengoko kuboniswe kwimigangatho emithathu ukuya kwemihlanu kumfanekiso ongentla.
Imimiselo kwimigangatho emithathu ukuya kwintlanu ikhupha ulwazi olumalunga nomhla wangoku - njengowoku kunyaka, inyanga, okanye imini-ngokusebenzisa umphumo we-TODAY umsebenzi kwiseli ye-A2 njengengxabano YONYAKA, YONYAKA, kunye nemisebenzi ye-DAY.
Umsebenzi we-TODAY ungasetyenziselwa ukubala ikhefu phakathi kwemihla emibini, njengenani leentsuku okanye iminyaka njengoko kuboniswe kwimigangatho yesithandathu kunye neyesisixhenxe kumfanekiso ongentla.
Imihla njengeNombolo
Imihla kwiifomula kwimigangatho yesithandathu no-7 iyakususwa omnye komnye kuba i-Excel izitolo zihamba njengeenombolo, ezifomathiweyo njengemihla kwiphepha lokusebenzela ukwenzela ukuba kube lula ngathi ukusebenzisa nokuqonda.
Umzekelo, umhla we-9/23/2016 (Septemba 23, 2016) kwiseli ye-A2 inenombolo ye-serial ye-42636 (inani leentsuku ukususela ngoJanuwari 1, 1900) ngeli xesha ngo-Oktobha 15, 2015 inenombolo yesi-42,292.
Ifom yokukhupha kwiseli ye-A6 isebenzisa la manani ukufumana inani leentsuku phakathi kwemihla emibini:
42,636 - 42,292 = 344
Kule ndlela kwifom ye-A6, umsebenzi we-Excel ka-DATE usetyenziselwa ukuqinisekisa ukuba umhla we-10/15/2015 ungeniswe kwaye ugcinwe njengemali yosuku.
Umzekelo kwiseli ye-A7 isebenzisa umsebenzi we-YEAR ukukhupha umnyaka okhoyo (2016) ukusuka kumsebenzi we-TODAY kwiseli A2 uze ususe kwi-1999 ukufumana umahluko phakathi kweminyaka emibini:
2016 - 1999 = 16
Ukukhupha iiDates UkuFomatha Inkinga
Xa ususa iintsuku ezimbini kwi-Excel, isiqhelo sisoloko siboniswa njengomnye umhla kunokuba inombolo.
Oku kwenzeka ukuba iseli equle ifomu ifomathiwe njengeGenerari ngaphambi kokuba ifom yefakwe. Ngenxa yokuba le fom iqulethe imihla, i-Excel iyitshintsha ifomathi yeseli ukuya kuMhla.
Ukujonga umphumo wefomula njengenombolo, ifomathi yefestile kufuneka ibuyiselwe kwi-Jikelele okanye kwiNombolo.
Ukwenza oku:
- Gqamisa iseli (s) ngefomathi engalunganga.
- Nqakraza nge mouse ukuze uvule imenyu yomongo.
- Kwimenyu, khetha iifomathi zefomathi ukuvula ibhokisi yencoko yencoko yefomathi.
- Kwibhokisi yencoko, nqakraza kwiTebhu yenombolo ukuba kuyimfuneko ukubonisa ukhetho lwefomathi.
- Ngaphantsi kweCandelo leCandelo, qhafaza kwi- Jikelele.
- Cofa OK ukuvala ibhokisi yencoko kwaye ubuyele kwiphepha lokusebenzela.
- Imiphumo yefomula ngoku kufuneka iboniswe njengenombolo.