Step 2– Now, in a separate cell, mention the Excel DATEDIF formula, which is=DATEDIF(start_date, end_date, unit) Step 3– Here, for this example, for the start date, select the rows accordingly, and for a unit in the formula, enter “y” (Note: Units always has to be mentioned ...
Excel 2021 for Mac Excel 2019 Excel 2016 Excel 2013 Excel 2010 Excel 2007SyntaxThe syntax of the DATEDIF formula is as follows −=DATEDIF(start_date,end_date,unit) ArgumentsYou can use the following arguments with the DATEDIF function −Argument...
The simplest and most accurate formula to calculate age in Excel is =DATEDIF(birth_date,as_of_date,"y"). This returns the number of years rounded down. Other methods, such as =INT((end-start)/365.25) or =INT(YEARFRAC(start,end)) are not 100% correct. See below for examples and an...
3. In cell C7, enter =DATEDIF($A7,$B7,”y”) 4. In cell D7, enter =DATEDIF($A7,$B7,”ym”) 5. In cell E7, enter =DATEDIF($A7,$B7,”md”) The result in cell E7 will be -1 which is clearly incorrect. To get the correct result of 2 in cell E7, try this formula inste...
{"__ref":"Forum:board:ExcelGeneral"},"subject":"Re: formule =datumverschil werkt niet / formula =datedif Excel does not work","readOnly":false,"editFrozen":false,"moderationData":{"__ref":"ModerationData:moderation_data:3776441"},"parent":{"__ref":"ForumReplyMessage:messa...
We use optional cookies to improve your experience on our websites, such as through social media connections, and to display personalized advertising based on your online activity. If you reject optional cookies, only cookies necessary to provide you the services will be used. You ma...