Access VBA Week Number of Year less Friday of that Week

[deer777]

I am trying to calculate a sum of a field called lines based on a specific week number of the year less one day of that week (Friday).

Please help! :doh:

Tks

[BrianMH]

Can you clarify what you mean by less one day of the week? Do you mean you want to calculate the weeknumber based on the start of the week being Friday? Or do you mean you don't want Fridays to be included in the calculation?