It can be entered as text strings in double-quotes, as serial numbers, or as a result of some other function, such as DATE(). start_date: It’s a date that represents the starting date value of the period.Syntax of DATEDIF function: =DATEDIF(start_date, end_date, unit) If not, you can skip this and move to the next section. If you’re interested in knowing more about DATEDIF function, read the content of the box below. This means that while you can use this function in Excel, you need to know the syntax and how many arguments this function takes. No tooltip appears when you use this function. One of the things that you’ll notice when you use this function is that there is no IntelliSense available for this function. For example, if you have the current date in cell B2, you can use the formula: =DATEDIF(B1,B2,"Y")ĭATEDIF function is provided for the compatibility with Lotus 1-2-3. If you have the current date (or the end date) in a cell, you can use the reference instead of the TODAY function. Suppose you have the date of birth in cell B1, and you want to calculate how many years have elapsed since that date, here is the formula that’ll give you the result: =DATEDIF(B1,TODAY(),"Y") You can also download the Excel Age Calculator Template. The number of Years, Months, and Days elapsed till the specified date.The number of years elapsed till the specified date.
Unit calculator free download how to#
In this tutorial, you’ll learn how to calculate age in Excel in: Calculate Age in Excel – Years, Months, & Days.How to Calculate Age in Excel using Date of Birth.
0 kommentar(er)
