Pogwiritsa ntchito DATEDIF kuwerengera masiku, miyezi, kapena zaka mu Excel

Sungani nthawi kapena kusiyana pakati pa masiku awiri

Excel ili ndi ntchito zingapo zomwe zingagwiritsidwe ntchito powerenga nambala ya masiku pakati pa masiku awiri.

Tsiku lililonse ntchito imagwira ntchito yosiyana kuti zotsatira zikhale zosiyana ndi ntchito imodzi. Chomwe mumagwiritsa ntchito, chotero chimadalira zotsatira zomwe mukufuna.

Ntchito ya DATEDIF ingagwiritsidwe ntchito powerengera nthawi kapena kusiyana pakati pa masiku awiri. Nthawi iyi ikhoza kuwerengedwera mwa:

• masiku
• miyezi yonse
• zaka zonse

Kugwiritsira ntchito ntchitoyi kumaphatikizapo kukonzekera kapena kulembera zokambirana kuti mudziwe nthawi ya polojekiti yomwe ikubwera. Ikhoza kugwiritsidwanso ntchito, kuphatikizapo tsiku la kubadwa kwa munthu, kuti awerengere msinkhu wake m'zaka, miyezi, ndi masiku .

Syntax ndi Maganizo a DATEDIF Function

Syntax ya ntchito imatanthawuza momwe ntchitoyo ikuyendera ndipo imaphatikizapo dzina la ntchito, mabaki, ndi zifukwa .

Chidule cha ntchito ya DATEDIF ndi:

= DATEDIF (start_date, end_date, unit)

kuyamba_date - (chofunika) tsiku loyamba la nthawi yosankhidwa. Tsiku loyambirira lenileni likhoza kulowetsedweratu pazokambiranazi kapena selo loyang'ana pa malo a deta iyi mu tsamba lothandizira likhoza kulowa mmalo mwake.

mapeto_date - (zofunikira) tsiku lomaliza la nthawi yosankhidwa. Monga ndi Start_date, lowetsani tsiku lomalizira kapena selo loyang'ana malo komwe deta iyi ikugwirira ntchito.

gawo (kale lotchedwa nthawi) - (lofunika) limauza ntchito kuti ipeze nambala ya masiku ("D"), miyezi yokwanira ("M"), kapena zaka zonse ("Y") pakati pa masiku awiriwo.

Mfundo:

1. Excel imapanga mawerengedwe a tsiku powasintha masiku kuti akhale nambala , zomwe zimayambira pa zero tsiku lachinyengo la January 0, 1900 pa makompyuta a Windows ndi January 1, 1904 pa makompyuta a Macintosh.
2. Mtsutso wothandizira uyenera kukhala wozunguliridwa ndi zizindikiro za quotation monga "D" kapena "M".

Zambiri pa Chigwirizano cha Unit

Mgwirizano wa magulu angakhalenso ndi masiku angapo, miyezi, ndi zaka kuti mupeze nambala ya miyezi pakati pa masiku awiri chaka chomwecho kapena chiwerengero cha masiku pakati pa masiku awiri mwezi womwewo.

• "YD" - iwerengetsera chiwerengero cha masiku pakati pa masiku awiri ngati masiku ali m'chaka chomwecho (mzere 5 pamwambapa).
• "YM" - iwerengetsera chiwerengero cha miyezi pakati pa masiku awiri ngati masiku ali m'chaka chomwecho (mzere 6 pamwambapa).
• "MD" - iwerengetsera chiwerengero cha masiku pakati pa masiku awiri ngati masiku ali mwezi umodzi ndi chaka (mzere 7 pamwambapa).

DATEDIF Zogwira Ntchito Zolakwika

Ngati deta yamaganizo osiyanasiyana a ntchitoyi siinalowe molondola malingaliro otsatirawa akuwoneka mu selo kumene DATEDIF ntchito ili:

• #VALUE! kulakwitsa - kubwereranso ngati ayamba_date kapena kutha_dali sizinali masiku enieni (mzere 8 pamwamba, pomwe selo A8 ili ndi deta).
• #NUM! Cholakwika - kubwerera ngati kutha _date ndi tsiku loyambirira kuposa start_date (mzere 9 pamwambapa).

Chitsanzo: Lembani kusiyana pakati pa masiku awiri

Mfundo yosangalatsa yokhudza DATEDIF ndi yakuti ntchito yosabvundika siinayanjedwe ndi zina Tsiku lomwe limagwira ntchito pansi pa tsamba lachitsanzo mu Excel, kutanthauza:

1. palibe bokosi lazokambirana lomwe likupezeka kuti ligwire ntchito ndi zifukwa zake.
2. chothandizira tooltip sichiwonetsa mndandanda wamakangano pamene dzina la ntchito likuyimikidwa mu selo.

Chotsatira chake, ntchito ndi zifukwa zake ziyenera kulowetsedwa mu selo kuti zigwiritsidwe ntchito, kuphatikizapo kulemba comma pakati pa mtsutso uliwonse kuti ukhale wolekanitsa.

DATEDIF Chitsanzo: Kuwerengera Kusiyana M'masiku

Masitepe otsatirawa ndi momwe mungalowetse ntchito DATEDIF yomwe ili mu selo B2 mu chithunzi pamwambapa chomwe chikuwonetsera chiwerengero cha masiku pakati pa May 4, 2014 ndi August 10, 2016.

1. Dinani pa selo B2 kuti mupange selo yogwira ntchito - apa ndi pamene chiwerengero cha masiku pakati pa masiku awiri chiwonetsedwe.
2. Mtundu = datedif ( "mu selo B2.
3. Dinani pa selo A2 kuti mulowetse seweroli ngati ndondomeko yoyamba_date ya ntchitoyi.
4. Lembani comma ( , ) mu selo B2 motsatira selo la A2 kuti likhale lolekanitsa pakati pa mfundo zoyamba ndi zachiwiri.
5. Dinani pa selo A3 mu spreadsheet kuti mulowetse selo ili ngati ndondomeko yomaliza_date.
6. Lembani kachiwiri kachiwiri ( , ) kutsatira chilolezo cha A3.
7. Pogwirizana ndi gululi , lembani kalata D mu ndemanga ( "D" ) kuti mudziwe ntchito imene tikufuna kudziwa masiku angapo pakati pa masiku awiriwo.
8. Lembani chithunzi chotsatira ")".
9. Lembani fungulo lolowamo lolowera mubokosilo kuti mukwaniritse chithunzicho.
10. Chiwerengero cha masiku - 829 - chiyenera kuonekera mu selo B2 la tsamba.
11. Mukasindikiza pa selo B2 ndondomeko yonse = DATEDIF (A2, A3, "D") ikuwoneka muzenera zamatabwa pamwamba pa tsamba.