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 th...
HansVogelaar
Jan 27, 2021MVP
Use the ISOWEEKNUM function instead of WEEKNUM.
- Markus70Jan 28, 2021Copper Contributor
Thank you.HansVogelaar