DATEDIF Problem

[Mike20878]

I'm comparing the dates 6/9/21 and 12/31/21 in cells G19 and M19, respectively.  My formula is =DATEDIF(G19,M19,"d").  I'm getting 44,561!

Thanks.

[#2 · Accepted solution]

@Mike20878 

44561 is number value for Dec 31, 2021. Perhaps G19 is blank or like. Could you share sample file or at least screenshot?

In general =M19-D19 and =DATEDIF(G19,M19,"d") return the same.

[#3]

This is weird. I reopened the file and just did M19-G19 (I had tried it before with the same result) and now I get 205.