Subtract formula in excel8/11/2023 ![]() 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 |