Jan 27 2021 12:31 PM
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.
Jan 27 2021 12:41 PM
Use the ISOWEEKNUM function instead of WEEKNUM.