DATEDIF function giving different values as shown in the snapshot. Why this?

CodePudding user response：

First of all, you should avoid passing D2 directly to DATEDIF formula. DATEDIF requires first 2 arguments as a date. You pass 0 and D2 (C2-B2). Since lowest possible date in excel is 01-Jan-1900 and it is = 1, your arguments are 0 = 0-Jan-1900 (non existing date) and 546 = 29-Jun-1900. You would get more errors in calculation if your dates would include leap year (1900 is not leap year)

Also consider looking at