Forum Discussion
pr09082000
Sep 16, 2021Copper Contributor
How to use DATEDIF as a number?
Hello guys, I have two datetime at cell G2, H2, for example 9/12/2021 21:49 and 9/13/2021 11:18, when I use DATEDIF(G2, H2, "d") the result is 1. However, I want to do some calculation with that res...
Riny_van_Eekelen
Sep 16, 2021Platinum Contributor
pr09082000 Created a mock-up on the basis of your description and used some values in D2 and I2 to get a result. I suspect that either of the values in these two cells are not real numbers, as that will return the #VALUE# error.