The formulas can now be simplified as follows:
WeekYear:
Year(DateField + Days(4 - Weekday(DateField)))
WeekNum:
RoundUp(
ToDays(
DateField - (Date(WeekYear, 1, 1) + Days(3 - Weekday(Date(WeekYear, 1, 4))))
) / 7,
0
)
1 Like