I have a couple of Excel formula's that I need to add into my SharePoint Lists. Below are the formula's as they are in Excel. I just need to know how I can change them to the appropriate syntax that will allow for a SharePoint List calculated column.
=IF([@[Actual Completion Date]]="",NETWORKDAYS([@[Date Prioritised]],TODAY()),NETWORKDAYS([@[Date Prioritised]],[@[Actual Completion Date]]))
See Formula attached
[1]: /answers/storage/attachments/87368-image.png

