Forum Discussion
Calculated date difference excluded public holiday and weekend
Hi, everyone, i am trying to use calculated type column to calculate the date difference. =NETWORKDAYS(start date, end date, (List of public holiday)). The public dates are saved in sharepoint lis...
thomascheung No, this is a known limitation of SharePoint calculated columns.
Calculated column formula can only reference the column values from same list item/row. It cannot access column values (data) from other lists in SharePoint site.
Even if you use lookup columns, those are not supported in calculated column formula.
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
