Ukuze ubale ubude bezikhawu zedethi ku-Excel kunomsebenzi I-RAZNDAT, enguqulweni yesiNgisi - DATEDIF.
I-nuance iwukuthi ngeke uwuthole lo msebenzi ohlwini lwe-Function Wizard ngokuchofoza inkinobho fx - isici esingabhaliwe se-Excel. Ngokunembe kakhudlwana, ungathola incazelo yalo msebenzi nezimpikiswano zawo kuphela enguqulweni ephelele yosizo lwesiNgisi, njengoba eqinisweni ishiywe ukuze ihambisane nezinguqulo ezindala ze-Excel kanye ne-Lotus 1-2-3. Nokho, naphezu kweqiniso lokuthi lo msebenzi awukwazi ukufakwa ngendlela evamile ngefasitela Faka – Umsebenzi (Faka - Umsebenzi), ungayifaka mathupha kuseli ukusuka kukhibhodi - futhi izosebenza!
I-syntax yomsebenzi imi kanje:
=RAZNDAT(Usuku okuqalwa ngalo; Idethi yokugcina; Indlela_yokulinganisa)
Ngama-agumenti amabili okuqala, yonke into isobala kakhulu - lawa amaseli anedethi yokuqala neyokuphela. Futhi impikiswano ethakazelisa kakhulu, yebo, ngeyokugcina - inquma kahle ukuthi isikhawu phakathi kwezinsuku zokuqala nezokugcina sizokalwa kanjani futhi kumaphi amayunithi. Le parameter ingathatha amanani alandelayo:
| "No" | umehluko wonyaka ogcwele |
| "M" | ezinyangeni ezigcwele |
| "D" | ngezinsuku ezigcwele |
| "yd" | umehluko ngezinsuku kusukela ekuqaleni konyaka, ngaphandle kweminyaka |
| "Md" | umehluko ngezinsuku ngaphandle kwezinyanga neminyaka |
| "phakathi" | umehluko ezinyangeni ezigcwele ngaphandle kweminyaka |
Ngokwesibonelo:
Labo. uma ufisa, bala futhi ubonise, isibonelo, ulwazi lwakho ngendlela “yeminyaka emi-3 nezinyanga ezi-4. izinsuku eziyi-12”, kufanele ufake ifomula elandelayo kuseli:
u1d RAZDAT (A2; A1; “y”)&” y. “& RAZDAT (A2; A1; “ym”) & ” inyanga. “&RAZDAT(A2;AXNUMX;”md”)&” izinsuku”
lapho i-A1 iyiseli enosuku lokungena emsebenzini, i-A2 idethi yokuxoshwa.
noma enguqulweni yesiNgisi ye-Excel:
=DATEDIF(A1;A2;»y»)&» y. «&DATEDIF(A1;A2;»ym»)&» m. «&DATEDIF(A1;A2;»md»)&» d.»
- Ulenza kanjani ikhalenda lokudonsela phansi ukuze ufake ngokushesha noma iyiphi idethi ngegundane kunoma iyiphi iseli.
- I-Excel isebenza kanjani namadethi
- Indlela yokwenza idethi yamanje ifakwe ngokuzenzakalelayo kuseli.
- Ungathola kanjani ukuthi izikhawu zedethi ezimbili ziyedlulana nokuthi zingaki izinsuku