calendar week in pivot table

%3CLINGO-SUB%20id%3D%22lingo-sub-2103522%22%20slang%3D%22en-US%22%3Ecalendar%20week%20in%20pivot%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2103522%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3EI%20am%20using%20a%20production%20schedule%20in%20excel%20with%20cw%20and%20year.%20Today%20(01%2F27%2F21)%20shows%20as%20week%2005%2C%20but%20we%20are%20actually%20in%20week%204.%20Jan%201st.%20showed%20up%20as%20week%2053.%20Can't%20figure%20out%20how%20to%20change%20the%20cw%20setting%20in%20excel.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2103522%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2103601%22%20slang%3D%22en-US%22%3ERe%3A%20calendar%20week%20in%20pivot%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2103601%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F945173%22%20target%3D%22_blank%22%3E%40Markus70%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EUse%20the%20ISOWEEKNUM%20function%20instead%20of%20WEEKNUM.%3C%2FP%3E%3C%2FLINGO-BODY%3E
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

@Markus70 

Use the ISOWEEKNUM function instead of WEEKNUM.

Thank you.@Hans Vogelaar