0

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

https://support.office.com/en-US/client/results?Shownav=true&lcid=1033&ns=SPOStandard&version=16&omkt=en-US&ver=16&HelpId=WSSEndUser_FormulaSyntaxError

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

1

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

Reference: DATEDIF function

1
  • 1
    that's what it was. Thanks Ganesh
    – SunMan
    Commented 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.