![]() "ym" gets the months between dates, ignoring days and years "md" gets the days between dates, ignoring months and years Start_date : First date in a valid excel formatĮnd_date : Second date in a valid excel format Syntax: =DATEDIF(start_date, end_date, unit) Basically it's a subtraction function for dates in excel as this function returns the number expressed as calendar period.ĭATEDIF function returns the number of years, months and days between the given two dates in Excel. DATEDIF function in excel to get the age of a person. It exists, use the function as explained and you will get the result.ĭATEDIF function is an excel function to get the complete calendar period between the two dates. You can choose the today's date using the today function explained in the example to calculate the age of a person in days, months or years in Excel.ĭon't get afraid if excel doesn't help you find the function. Or you can use the Excel DATEDIF function. There could be a simple way to just subtract the latest date from the older date. How can you calculate days between two dates ? In this article, we will learn How to use the DATEDIF function in Excel.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |