Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 3 of 3 FirstFirst 123
Results 21 to 23 of 23

Thread: Getting "Week of Month"

  1. #21
    New Member
    Join Date
    Oct 2012
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Getting "Week of Month"

    But, much more importantly, it turns out that Sankar's solution at the very top of page 2 does what I needed MUCH more simply, and without any inconsistency whatsoever. Not sure how I missed it earlier, but it is a truly clever and elegant solution.

  2. #22
    MrExcel MVP
    Moderator
    barry houdini's Avatar
    Join Date
    Mar 2005
    Location
    England
    Posts
    20,825
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Getting "Week of Month"

    The difference with that version is that it takes no account of the day of week, you simply get week 1 for the first 7 days of the month, Week 2 for the next 7 days etc.

  3. #23
    New Member
    Join Date
    Oct 2012
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Getting "Week of Month"

    Quote Originally Posted by barry houdini View Post
    The difference with that version is that it takes no account of the day of week, you simply get week 1 for the first 7 days of the month, Week 2 for the next 7 days etc.
    Correct. Buried deep in my original post is a reference to actually needing that, but given the <sarcsasm>brevity</sarcasm> of that post, I can see that it would be easily missed. And, for many folks that need a running count, this particular result may well not meet their requirements. Having played around with the initial formula, and your correction, I'm coming to the realization that, realistically, I think it would be necessary to write a VBA snippet, or a plug-in, to really deliver the functionality in a way that could meet the multiple potential requirements various users would need.

    It seems so simple until you actually need to do it yourself.
    Last edited by jetboy2k; Sep 4th, 2014 at 03:22 PM.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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