如何在Excel中快速將出生日期轉換為年齡? | excel年齡
HowtoconvertbirthdatetoagequicklyinExcel?ConvertbirthdatetoagewithformulasThebelowformulascanhelptocalculateagebasedonbirthdateinExcel.ConvertbirthdatetoagewiththeINTfunctionTheINTfunctioncanhelptocalculateapersonsagebasedongivenbirthdate,pleasedoasfollows.1.Supposingtherearetwocolumnscontainingbirthdateandcurrentdateseparately.2.Selectablankcelltooutputtheage,enterthebelowformulaintoitandpresstheEnterkey.SelecttheresultcellandthendragitsFillHandledowntogetallresults.=INT((B2-A2)/365)Convert...
How to convert birthdate to age quickly in Excel? Convert birthdate to age with formulasThe below formulas can help to calculate age based on birthdate in Excel.
Convert birthdate to age with the INT functionThe INT function can help to calculate a persons age based on given birthdate, please do as follows.
1. Supposing there are two columns containing birthdate and current date separately.
2. Select a blank cell to output the age, enter the below formula into it and press the Enter key. Select the result cell and then drag its Fill Handle down to get all results.
=INT((B2-A2)/365)
Convert birthdate to age with the DATEDIF functionThe below DATEDIF function can also help.
Select a blank cell to output the age, enter the below formula into it and press the Enter key. Select the result cell and then drag its Fill Handle down to get all results.
=DATEDIF(A2,NOW(),"y")