calendar week in pivot table

New Contributor

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 Replies


Use the ISOWEEKNUM function instead of WEEKNUM.

Thank you.@Hans Vogelaar