Share via

Wrong week numbering for 2021

Anonymous
2021-02-02T22:58:13+00:00

I am using MS Project Professional 2016

I have a problem with the weeks. For this new year 2021, the system is considering the Week 1, to start on Friday 1st of Januray. and consequently Week 2 starts on Monday 4th, which is incorrect. 

4.1.2021 -> CW 2 (Wrong! Should be 1).

Please your support on this matter. 

Regards,

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2021-02-03T03:35:20+00:00

    I don't use Project, but take a look to see if Project has the equivalent of the Excel ISOWeekNum() function:

    ISOWEEKNUM Function
    https://exceljet.net/excel-functions/excel-isoweeknum-function

    The Excel ISOWEEKNUM function takes a date and returns a week number (1-54) that follows ISO standards, where weeks begin on Monday and week number 1 isassigned to the first week in a year that contains a Thursday.
    .

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2021-02-03T02:37:01+00:00

    Unlike Excel or Outlook, Project does not always define week numbers according to established standards.  This has been discussed often:

    https://social.technet.microsoft.com/Forums/windows/en-US/d16d4282-5d49-4a90-bae7-e0d06cb52055/wrong-week-numbers?forum=projectprofessional2010general

    Was this answer helpful?

    0 comments
  3. John Project 49,715 Reputation points Volunteer Moderator
    2021-02-03T02:02:00+00:00

    DanielSanchez2021,

    Despite what Arissa O says, this IS the correct forum for your question.

    To answer your question, it depends on how you chose to display the timescale. In this simple example, the middle tier is set to display weeks as 1,2,...52 and the bottom tier is set to display weeks from the start. Pick the one that meets your needs

    Hope this helps.

    John

    Was this answer helpful?

    0 comments
  4. Anonymous
    2021-02-02T23:34:49+00:00

    Hello DanielSanchez2021! I'm Arissa, an independent advisor!

    This community is for regular users only, here's the link for the professional forum:

    https://techcommunity.microsoft.com/t5/project/...

    Kind regards,

    Arissa.

    Was this answer helpful?

    0 comments