Find my approach as reference below and stored in attached workbook version 9.3
Weeknr: Datepart('week',DATE(DATETRUNC('week', [Date]-5)))
costum weeknr..twbx 27.0 KB
Thanks for your help and this will certainly come in handy! Just wondering, would it possible to display week range instead of week number? For example, Week Number 42 would be 15-Oct 2016 - 21-10-2016.