Forum Discussion
52 weeks calculation
I want the week to start on Sunday in my calendar table for 2021 and 2022 ( 52 weeks), but that doesn't happen when I apply the weekum=(calendar date,1) -1. However, the last two days of the final we...
Can you show what your expected weeknum is for the first 7 days of each year (2020 and 2021)?
Pat
Sorry for being late, the first week of 2022 start on Sunday 01/02/22 and the last day is 01/08/22 as for 2021, the first week is from 12/27/20 to 01/02/21 (mm/day/year)