Results 1 to 19 of 19

Thread: Create Table with quartils

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #16
    VBAX Regular
    Joined
    Dec 2021
    Posts
    58
    Location
    I will upload it later (tomorow probably), but not here, the file is too big. I could paste my code here and send you the link to download the data.

    At least one problem I have solved. This is code to convert date to week no.
    TheDay = CDbl(Selection.Range("A5"))
    weekNo = (TheDay - 43831) / 7
    ' if weekNo > 1.1.2021 and weekNo<1.1.2022
    If (TheDay > 44196) And (TheDay < 44562) Then
      weekNo = weekNo - (44562 - 44196) ' weekNo -= 365
    End If
    Last edited by vangog; 12-26-2021 at 05:16 PM.

Posting Permissions

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