Forum Discussion
Solved
DATEDIF Problem
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.
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.
2 Replies
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.
- 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.
