What do you need to do with the week number? I am just trying to understand where you need to see it and how it will need to be used and updated.
This gives you the current week number:
RoundDown(
(
RoundUp(
DaveValue_DateSelected.SelectedDate-Date(Year(DaveValue_DateSelected.SelectedDate-Weekday(DaveValue_DateSelected.SelectedDate-1)+4),1,3),0)+
Weekday(Date(Year(DaveValue_DateSelected.SelectedDate-Weekday(DaveValue_DateSelected.SelectedDate-1)+4),1,3))+5)
/7,0)
And if it is just for a label you could just subtract 1 from it or something like that but it really depends on what you you are doing with it.
