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. The unit input there specifies the kind of difference you want to get from your dates. In the DATEDIF input, the earlier_date input part becomes the subtractor of the later_date.
