Forum Discussion

Holecek615's avatar
Holecek615
Copper Contributor
Feb 16, 2022
Solved

DATEDIF problem - doesnt show number of days difference

Hi, I need to evaluate the confirmed delivery date with real delivery date. For that I need see a difference between those 2 dates in days.   If I use DATEDIF, the result is a date (19.1.1900) or s...
excel
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    Feb 16, 2022

    Holecek615 

    Set the number format of the cells with the DATEDIF formula to General or to Number.

NikolinoDE's avatar
NikolinoDE
Platinum Contributor
Feb 16, 2022
=DATEDIF(D2;F2;"D")
Use esta corrección donde ocurra el error. D y F están en orden incorrecto.

  • Holecek615's avatar
    Holecek615
    Copper Contributor
    Feb 16, 2022
    ok, so the sooner date, than the later date. Got it, thank you!

Resources