Sebenzisa Usuku Lwanamhlanje kuma-Worksheet Calculations ku-Excel

Indlela yokusebenza ngezinsuku ku-Excel

Umsebenzi wanamuhla ungasetshenziswa ukwengeza usuku lwamanje kushidi lokusebenzela (njengoba kuboniswe emgqeni wesithombe esingenhla) nangesikhathi sokubala (kuboniswe emigqeni amathathu kuya kweyisikhombisa ngenhla).

Kodwa-ke, umsebenzi, ungomunye wemisebenzi engaxhunyiwe ka-Excel okusho ukuthi ngokuvamile uyazivuselela njalo uma ishidi lomsebenzi eliqukethe umsebenzi lihlelwa kabusha.

Ngokuvamile, ama-worksheets aphinde avuselele njalo lapho evuliwe ngakho nsuku zonke ukuthi ishidi lomsebenzi livuliwe usuku luzoshintsha ngaphandle kokuthi ukuvuselelwa okuzenzakalelayo kuvaliwe.

Ukuze uvimbele ukuba noshintsho lusuku ngalunye uma ishidi lokusebenzela livuliwe kabusha, zama ukusebenzisa lesi shintsho sekhibhodi ukuze ufake usuku lwamanje kunalokho.

I-Syntax ne-Arguments Namuhla

I- syntax yomsebenzi ibhekisela kokuhlelwa komsebenzi futhi ihlanganisa igama lomsebenzi, amabakaki, ukwahlukanisa kwama-comma, nokuphikisana .

I-syntax yomsebenzi we-TODAY ngu:

= NAMUHLA ()

Lo msebenzi awunazo izimpikiswano ezingasetshenziswa ngesandla.

Namuhla usebenzisa usuku lwe- serial lwe-computer - olugcina usuku nosuku lwamanje njengenombolo - njengengxabano. Ithola lolu lwazi ngosuku olukhona ngokufunda iwashi lekhompyutha.

Ukufaka Usuku Lwanamuhla NOMSEBENZI WENYAKA

Izinketho zokufaka umsebenzi we-TODAY zihlanganisa:

1. Ukuthayipha umsebenzi ophelele: = NAMUHLA () kuseli leshidi lokusebenzela
2. Ukufaka umsebenzi usebenzisa ibhokisi lengxoxo ye- TODAY

Kusukela umsebenzi we-DAY namhlanje awunazo izimpikiswano ezingangena ngesandla, abantu abaningi bakhetha ukuthayipha nje emsebenzini ngaphandle kokusebenzisa ibhokisi lengxoxo.

Uma Usuku Lwanamuhla Lungavuseleli

Njengoba kukhonjisiwe, uma umsebenzi we-TODAY ungabuyekezi ngosuku olukhona ngaso sonke isikhathi uma ishidi livuliwe, kungenzeka ukuthi ukuvuselelwa okuzenzakalelayo kwencwadi yokusebenza kuvaliwe.

Ukuqalisa ukulungiswa okuzenzakalelayo:

1. Chofoza kuthebhu yefayela yebhebhoni ukuvula imenyu yefayela.
2. Chofoza kuzinketho kwimenyu ukuvula ibhokisi lengxoxo ye-Excel.
3. Chofoza kwi- Formulas inketho ngakwesokunxele kwesandla sokungena ukuze ubuke izinketho ezitholakalayo efasiteleni lesandla sokunene ebhokisini lengxoxo.
4. Ngaphansi kwesigaba sezinketho zokuBhaliswa kwaBasebenzi , chofoza ku- Automatic ukuvula ukulungiswa okuzenzakalelayo.
5. Chofoza OK ukuvala ibhokisi lengxoxo bese ubuyela ekhasini lokusebenzela.

Ukusebenzisa NAMUHLA ngezibalo zosuku

Ukusebenza kweqiniso kweNHLANGANO YENYAKA kuyacaca uma isetshenziselwa ukubalwa kwamalanga - ngokuvamile ngokuhambisana neminye imisebenzi yosuku lwe-Excel - njengoba kuboniswe emigqeni amathathu ukuya kwemihlanu esithombeni ngenhla.

Izibonelo emigqeni yolwazi lokukhishwa kwezintathu eziyisihlanu ezihlobene nosuku lwamanje - njengonyaka wamanje, inyanga, noma ilanga - ngokusebenzisa ukukhishwa komsebenzi we-MANJE kuseli cell A2 njengengxabano ye-YEAR, MONTH, ne-DAY imisebenzi.

Umsebenzi wanamuhla ungasetshenziselwa ukubala isikhathi phakathi kwezinsuku ezimbili, njengezinombolo zezinsuku noma iminyaka njengoba kuboniswe emigqeni eyisithupha nesikhombisa esithombeni ngenhla.

Izinsuku njengezinombolo

Izinsuku ezifomula emigqeni eyisithupha nesikhombisa zingasuswa kusuka komunye nomunye ngoba izitolo ze-Excel zihamba njengezinombolo, ezifomathiwe njengezinsuku kuphepha lokusebenzela ukuze zenze kube lula ngathi ukusebenzisa nokuqonda.

Isibonelo, usuku olungu-9/23/2016 (Septhemba 23, 2016) esitokisini se-A2 linombhalo wezinombolo ezingu-42636 (inani lezinsuku kusukela ngoJanuwari 1, 1900) ngenkathi u-Okthoba 15, 2015 unenombolo yesibili engu-42 292.

Ifomula yokukhipha esitokisini A6 isebenzisa lezi zinombolo ukuthola inombolo yezinsuku phakathi kwezinsuku ezimbili:

42,636 - 42,292 = 344

Kumfomula ku-cell A6, umsebenzi we-Excel ka-DATE usetshenziselwa ukuqinisekisa ukuthi usuku olungu-10/15/2015 lufakwe futhi lulondolozwe njengenani lamanani.

Esikhathini esisefenjini le-A7 isebenzisa umsebenzi we-YEAR ukukhipha unyaka wamanje (2016) kusuka kumsebenzi we-TODAY esitokisini A2 bese usususa kusukela ngo-1999 ukuthola umehluko emkhatsini weminyaka emibili:

2016 - 1999 = 16

Ukukhipha Izinsuku Zokufometha Kwezinsuku

Uma ususa amadethi amabili ku-Excel, umphumela uvame ukuboniswa njengenye idethi esikhundleni senombolo.

Lokhu kwenzeka uma iseli eliqukethe ifomu lifomathiwe njengeGenerali ngaphambi kokuba ifomula ingenwe. Ngenxa yokuthi ifomula iqukethe izinsuku, i-Excel iyashintsha ifomethi yeseli kuze kube usuku.

Ukuze ubuke umphumela wefomula njengenombolo, ifomethi yeseli kumele ibuyiswe kuGenerali noma kuNombolo.

Ukwenza lokhu:

1. Qinisekisa iseli (ama) ngokufometha okungalungile.
2. Chofoza ngakwesokudla ngegundane ukuvula imenyu yesimo.
3. Emenyu, khetha Amaseli Wefomathi ukuvula ibhokisi lezingxoxo zefomathi.
4. Ebhokisini lengxoxo, chofoza kuthebhu yezinombolo uma kunesidingo ukubonisa Izinketho zokufometha Izinombolo.
5. Ngaphansi kwesigaba seGigaba, chofoza ku- Jikelele.
6. Chofoza OK ukuvala ibhokisi lengxoxo bese ubuyela ekhasini lokusebenzela.
7. Imiphumela yefomula kufanele iboniswe njengenombolo.