Microsoft Excel Webinar

Results 1 to 2 of 2

Thread: Access VBA Week Number of Year less Friday of that Week

  1. #1

    Question Access VBA Week Number of Year less Friday of that Week

    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!

    Tks

  2. #2
    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?
    -----------------------------------------
    The more you learn about something the more you know you have much to learn.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •