calendar week in pivot table

[Markus70]

Hi all,

I am using a production schedule in excel with cw and year. Today (01/27/21) shows as week 05, but we are actually in week 4. Jan 1st. showed up as week 53. Can't figure out how to change the cw setting in excel.

[#2]

@Markus70 

Use the ISOWEEKNUM function instead of WEEKNUM.

[#3]

Thank you.@Hans Vogelaar