Skip to main content
SharePoint

Return to Question

edited tags
Link
Ganesh Sanap - MVP
Ganesh Sanap - MVP
  • 46.4k
  • 22
  • 31
  • 63
edited body; edited tags; edited title
Source Link
Ganesh Sanap - MVP
Ganesh Sanap - MVP
  • 46.4k
  • 22
  • 31
  • 63

Datedif DATEDIF function returning wrong number of days

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

Datedif function returning wrong number of days

I am not able to get 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

DATEDIF function returning wrong number of days

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

edited body
Source Link
SunMan
SunMan
  • 107
  • 1
  • 2
  • 7

I am not able to get 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 hereenter image description here

I am not able to get 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

I am not able to get 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

Post Undeleted by SunMan
Post Deleted by SunMan
Source Link
SunMan
SunMan
  • 107
  • 1
  • 2
  • 7