Hello, please advise me how to calculate the Week Number from another item of type Date in an item of type Counted field in a table. Something like the Weeknum function in excel.
Thank you. Milan
Hello, in the calculated field, we don’t have any function similar to Excel’s Weeknum. Try writing a script in WF where you can write a script for various situations. Here’s a link where you could write a script for the number of weeks in JS: Get Week Number of the Year in JavaScript | Delft Stack.
With regards, Filip Tabidoo