How we can reset week number monthly wise, now it is calculating yearly wise
Week([Ship date]) - Week(DateAdd("dd",(-DayOfMonth([Ship date])) + 1,[Ship date])) + 1
the resulting week can go up to six if a month has four complete weeks but two partial weeks at the start and end.
This Question already has a 'Best Answer'. If you believe this answer is better, you must first uncheck the current Best Answer