I am not able to get the number of days between start and end dates.

I am using DATEDIF(Start_date,End_date,"D") which seems correct as per articles


Calculated Field with formula DATEDIF

and I think I have set it up right but not able to figure out. Here is the picture, if you can spot what I am not seeing...thanks team.

enter image description here

1 Answer 1


Select Number under The data type returned from this formula is: option in column settings.

Reference: DATEDIF function

  • 1
    that's what it was. Thanks Ganesh
    – SunMan
    Aug 20, 2021 at 10:34

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.