+ Reply to Thread
Results 1 to 3 of 3

Week Number of Month View Control

  1. #1
    Registered User
    Join Date
    06-22-2018
    Location
    suisse
    MS-Off Ver
    office 2016
    Posts
    59

    Week Number of Month View Control

    Hello,
    I have the following problem with the month view control, with the code bellow i get week 53 when in the Month view it shows week 1.

    Please Login or Register  to view this content.
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,920

    Re: Week Number of Month View Control

    Try this:
    Please Login or Register  to view this content.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

  3. #3
    Registered User
    Join Date
    06-22-2018
    Location
    suisse
    MS-Off Ver
    office 2016
    Posts
    59
    Quote Originally Posted by dflak View Post
    Try this:
    Please Login or Register  to view this content.
    I’ve already tested that but the problem is that for example the year 2020 has really 53 weeks..i’ve Searched on the web but can’t seem to find a solution

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Week number in month determined by 3/4 weekdays in week within said month
    By atearth in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2017, 02:36 PM
  2. [SOLVED] Calculate Week Range from Week Number, Month and Year?
    By A108A108 in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 05-07-2016, 03:11 PM
  3. [SOLVED] Month View control on userform works but can't use it in more than one cell.
    By rimshot609 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-17-2015, 03:06 PM
  4. [SOLVED] Month View Control to locate future date (Or Red Circle)
    By Excelnoub in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-07-2014, 12:23 PM
  5. Excel 2010 Month View Control missing
    By Luphai in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-25-2013, 08:48 AM
  6. Replies: 10
    Last Post: 01-22-2012, 10:05 AM
  7. [SOLVED] Month View control to disabled specific days
    By Ben in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-30-2005, 03:30 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1