Forum Discussion
Non-developer here, how do I write SharePoint Calculations for:
You could try below formula:
=IF(AND([Hold End Date]>0,[Hold Begin Date]>0),DATEDIF([Hold Begin Date],[Hold End Date],"d"),IF([Hold Begin Date]>0,DATEDIF([Hold Begin Date],TODAY(),"d"),"0"))Make sure that you are using correct internal name of both the column in formula. Get hint from this link if you don't know how to find internal name of the column
Official Documentation: https://docs.microsoft.com/en-us/previous-versions/office/developer/sharepoint-2010/bb862071(v=office.14)
Hope it will helpful to you and if so then Please mark my response as Best Response & Like to help others in this community
You could try below formula:
=IF(AND([Hold End Date]>0,[Hold Begin Date]>0),DATEDIF([Hold Begin Date],[Hold End Date],"d"),IF([Hold Begin Date]>0,DATEDIF([Hold Begin Date],TODAY(),"d"),"0"))
Make sure that you are using correct internal name of both the column in formula. Get hint from this link if you don't know how to find internal name of the column
Official Documentation: https://docs.microsoft.com/en-us/previous-versions/office/developer/sharepoint-2010/bb862071(v=office.14)
Hope it will helpful to you and if so then Please mark my response as Best Response & Like to help others in this community
- kalpeshvaghela Thank you not only for the solution, but also the helpful hints.
