Forum Discussion
MichelleChapman
7 years agoQrew Assistant Captain
I'm close with this function but this has the year starting on the literal Jan 1 2019-Tuesday when I need it to start Sunday 12/30/18 and the first week would end 1/5/19
Int(DayOfYear([Process Date])/7+1)
Int(DayOfYear([Process Date])/7+1)