But, if you use a “YM” unit input, then the result becomes 3 (because DATEDIF will only calculate the month difference and ignore the year difference).Īs an example to make it clearer, here is the writing and result example of DATEDIF in excel.Īs you can see in the DATEDIF writing example, we use “MD” unit input to calculate the date difference. Because of that, 12 months will be added to the result). That is because DATEDIF also considers the year numbers from those two dates (the month difference is 3 but because it considers the year difference also which is 1. ![]() If you use an “M” unit input, then the result will be 15. That is, of course, if you use the unit which includes, not excludes, the month and/or year numbers.Īs an example, let’s say your earlier date is 12-02-2020 and your later date is 14-05-2021. The meaning of including month and/or year in the additional note column is DATEDIF will calculate those variables if needed. ![]() Here is the list of all the unit inputs you can give in DATEDIF and their brief explanation.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |