Forum Discussion
Markus70
Jan 27, 2021Copper Contributor
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.
2 Replies
Use the ISOWEEKNUM function instead of WEEKNUM.
- Markus70Copper Contributor
Thank you.HansVogelaar