Tsuas los ntawm rho tawm hnub yug los ntawm hnub tam sim no Cov qauv hnub nyoog no kuj tseem siv tau hauv Excel. Thawj ntu ntawm cov qauv (TAUDAY-B2) rov qab qhov sib txawv ntawm hnub tam sim no thiab hnub yug yog hnub, thiab tom qab ntawd koj faib tus lej ntawd los ntawm 365 kom tau txais cov lej xyoo.
Kuv yuav suav hnub nyoog li cas los ntawm hnub tshwj xeeb hauv Excel?
Tus qauv yooj yim thiab raug tshaj plaws los xam hnub nyoog hauv Excel yog =DATEDIF(birth_date, as_of_date, "y"). Qhov no rov qab tus naj npawb ntawm xyoo sib npaug.
Yuav ua li cas thiaj xam hnub nyoog?
Txoj kev suav hnub nyoog suav nrog kev sib piv ntawm tus neeg lub hnub yug nrog hnub uas muaj hnub nyoog yuav tsum tau suav. Hnub yug yog muab rho tawm ntawm lub hnub yug, uas muab lub hnub nyoog ntawm tus neeg. Hnub nyoog=Muab hnub - Hnub yug.
Kuv yuav xam hnub nyoog li cas hauv mm/dd/yyyy hauv Excel?
Hloov hnub yug rau hauv lub xovtooj ntawm hom MM/DD/YYYY (yog tias nyob hauv Tebchaws Meskas) lossis hauv hom DD/MM/YYYY yog tias koj lub tebchaws siv hom ntawv ntawd. Type=DATEDIF(XX, TODAY, “Y”) ces nias Enter ntawm koj cov keyboard.
Puas Google Sheets xam hnub nyoog txij hnub yug?
Google Sheets tuaj yeem siv rau ntau dua li kev khaws cov ntaub ntawv thiab koom haum. Koj tseem tuaj yeem siv nws los txiav txim lub sijhawm tam sim no, tsim cov kab kos, thiab suav hnub nyoog siv hnub yug. Cov tom kawg tau tshawb pom los ntawm kev siv cov qauv thiab cov haujlwm ua haujlwm hauv Google Sheets.
