Forum Discussion

Markus70's avatar
Markus70
Copper Contributor
Jan 27, 2021

calendar week in pivot table

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.

Resources