Suav hnub nruab nrab ntawm ob hnub hauv Excel

Cov txheej txheem:

Suav hnub nruab nrab ntawm ob hnub hauv Excel
Suav hnub nruab nrab ntawm ob hnub hauv Excel
Anonim

Microsoft Excel nta ntau lub luag haujlwm los pab cov neeg siv suav cov hnub ua haujlwm ntawm ob hnub lossis nrhiav hnub pib thiab hnub kawg ntawm qhov haujlwm tau muab cov hnub ua haujlwm. Cov haujlwm no yog ib qho yooj yim rau kev npaj thiab thaum sau cov lus pom zoo los txiav txim siab lub sijhawm ntawm qhov project.

Ntawm no yog saib sai ntawm cov haujlwm tseem ceeb ntawm Excel hnub ua haujlwm nrog rau qhov twg kom pom cov ntaub ntawv ntau ntxiv.

Cov haujlwm no muaj nyob hauv Excel versions 2007 thiab tom qab, tshwj tsis yog tias tau teev tseg, nrog rau Excel rau Microsoft 365, Excel rau Microsoft 365 rau Mac, Excel 2016 rau Mac, thiab Excel rau Mac 2011.

Excel NETWORKDAYS Function

Siv NETWORKDAYS muaj nuj nqi los xam cov hnub ua haujlwm ntawm hnub pib thiab hnub kawg ntawm qhov project. Nws tsis suav cov hnub so thiab hnub so rau qhov tseeb ntxiv.

Qhov kev siv tau rau NETWORKDAYS yog los suav cov neeg ua haujlwm cov txiaj ntsig uas suav nrog raws li cov hnub ua haujlwm thaum lub sijhawm tshwj xeeb.

Excel NETWORKDAYS. INTL Muaj nuj nqi

Lub NETWORKDAYS. INTL muaj nuj nqi zoo ib yam li NETWORKDAYS muaj nuj nqi, tshwj tsis yog tias koj siv NETWORKDAYS. INTL muaj nuj nqi rau cov chaw ua haujlwm uas cov hnub so tsis tas yuav poob rau hnub Saturday thiab Hnub Sunday. Ib hnub so rau hnub so, thiab. Txoj haujlwm no ua ntej muaj nyob hauv Excel 2010.

Excel DATEDIF muaj nuj nqi

Lub DATEDIF muaj nuj nqi suav cov hnub, hli, lossis xyoo ntawm ob hnub. Nws xa rov qab qhov sib txawv ntawm ob hnub nqi, raws li lub sijhawm teev tseg.

Excel WORKDAY Function

Siv WORKDAY muaj nuj nqi los xam hnub kawg lossis hnub pib ntawm qhov haujlwm rau ib hnub ua haujlwm. WORKDAY tuaj yeem tshem tawm cov hnub so lossis hnub so thaum koj suav cov hnub them nqi, lub sijhawm xa tuaj, lossis cov hnub ua haujlwm tau ua.

Excel WORKDAY. INTL Muaj nuj nqi

Zoo ib yam li Excel's WORKDAY ua haujlwm saum toj no, siv WORKDAY. INTL ua haujlwm thaum lub koom haum hnub so tsis poob rau hnub Saturday thiab hnub Sunday. Ib hnub so rau hnub so, thiab. Txoj haujlwm no ua ntej muaj nyob hauv Excel 2010.

Excel EDATE Function

Siv EDATE muaj nuj nqi los xam hnub kawg ntawm qhov project lossis peev uas poob rau tib hnub ntawm lub hli raws li hnub tau tshaj tawm.

Excel EOMONTH Function

Siv EOMONTH muaj nuj nqi, luv luv rau Lub Hlis kawg ua haujlwm, los xam hnub kawg ntawm qhov project lossis peev uas poob rau thaum kawg ntawm lub hli. EOMONTH kuj tseem siv tau los suav cov hnub kom loj hlob uas poob rau hnub kawg ntawm lub hli.

Excel DAYS360 Function

Siv Excel DAYS360 Kev Ua Haujlwm hauv kev suav nyiaj los suav cov hnub ntawm ob hnub raws li 360-hnub xyoo. Siv lub luag haujlwm no los pab suav cov nyiaj them yog tias koj lub kaw lus suav nrog 12 30-hnub lub hlis.

Hloov hnub nrog DATEVALUE

Image
Image

Siv DATEVALUE muaj nuj nqi los hloov hnub uas tau muab khaws cia ua cov ntawv rau hauv tus nqi uas Excel lees paub. Qhov no yuav ua tau yog tias cov ntaub ntawv hauv daim ntawv ua haujlwm yuav raug lim lossis txheeb xyuas cov hnub tseem ceeb, lossis yog cov hnub yuav raug siv rau hauv kev suav, xws li thaum siv NETWORKDAYS lossis WORKDAY ua haujlwm.

Pom zoo: