Kuwerengera nthawi ya nthawi zamasiku mu Excel pali ntchito RAZNDAT, m'Chingerezi - DATEDIF.
Chosangalatsa ndichakuti simupeza ntchitoyi pamndandanda wa Function Wizard podina batani fx - ndi gawo losalembedwa la Excel. Kunena zowona, mutha kupeza kufotokozera kwa ntchitoyi ndi mfundo zake mu mtundu wonse wa chithandizo cha Chingerezi, chifukwa chasiyidwa kuti chigwirizane ndi mitundu yakale ya Excel ndi Lotus 1-2-3. Komabe, ngakhale kuti ntchitoyi siyingayikidwe mwanjira yokhazikika pawindo Insert - Ntchito (Ikani - Ntchito), mutha kuyilowetsa pamanja mu selo kuchokera pa kiyibodi - ndipo idzagwira ntchito!
Syntax ya ntchito ndi motere:
=RAZNDAT(Tsiku loyambira; Tsiku lomaliza; Njira_ya_muyeso)
Ndi mikangano iwiri yoyambirira, zonse zimakhala zomveka bwino - awa ndi maselo okhala ndi masiku oyambira ndi omaliza. Ndipo mkangano wochititsa chidwi kwambiri, ndithudi, ndi wotsiriza - umatsimikizira momwe ndi m'mayunitsi apakati pakati pa masiku oyambira ndi otsiriza adzayesedwa. Parameter iyi ikhoza kutenga zinthu zotsatirazi:
| "Ndi" | kusiyana kwa chaka chonse |
| "M" | m'miyezi yathunthu |
| "D" | m'masiku athunthu |
| "yd" | kusiyana kwa masiku kuyambira chiyambi cha chaka, kupatula zaka |
| "Md" | kusiyana kwa masiku osaphatikizapo miyezi ndi zaka |
| "mu" | kusiyana kwa miyezi yathunthu kupatula zaka |
Mwachitsanzo:
Iwo. ngati mukufuna, werengerani ndikuwonetsa, mwachitsanzo, zomwe mwakumana nazo mu "zaka zitatu 3 miyezi. Masiku 4", muyenera kulowa m'selo:
u1d RAZDAT (A2; A1; “y”)&” y. "& RAZDAT (A2; A1; "ym") & "mwezi. "&RAZDAT(A2;AXNUMX;"md")&" masiku"
pomwe A1 ndi cell yokhala ndi tsiku lolowa ntchito, A2 ndiye tsiku lochotsedwa.
kapena m'Chingerezi cha Excel:
=DATEDIF(A1;A2;»y»)&»y. «&DATEDIF(A1;A2;»ym»)&» m. «&DATEDIF(A1;A2;»md»)&» d.»
- Momwe mungapangire kalendala yotsitsa kuti mulowe mwachangu tsiku lililonse ndi mbewa mu cell iliyonse.
- Momwe Excel imagwirira ntchito ndi madeti
- Momwe mungapangire tsiku lomwe lilipo kuti lilowe mu cell.
- Momwe mungadziwire ngati nthawi ziwiri zamasiku zikuphatikizana komanso masiku angati