get week number within the month from date

Question

1.00/5 (1 vote)

See more:

Hi,
I want to get the week number of date. For 04-11-2012, week number is 1 and for 11-11-2012 week number as 2. Please anyone help me.
Thank you.

Posted 1-Nov-12 1:39am

Zukiari

Updated 6-Feb-19 20:06pm

Add a Solution

Comments

OriginalGriff 1-Nov-12 8:04am

That can be quite complex - the ISO standard does not define when date is in what week (as it does for week number of year) so to a certain extent, it is going to depend on what rules you need to apply.
What day of the week does your week start? Sat, Sun, or Mon?
Is 1st of the month always in week one? Or does it follow the week of year rule and depend on the date of the Thursday?

5 solutions

Solution 4

VB

Private Function WeekNumberOfMonth(ByVal Dt As Date) As Integer
       Dim weekNumber As Integer = Math.Floor(Dt.Day / 7) + 1
       Return weekNumber
   End Function

By Elian Fernandez

Posted 4-Jun-15 9:51am

Member 10748738

Solution 6

Redundant code with exact solution as below Method/Function based on passed date,

private static int GetWeekNumberOfMonth(DateTime date)
       {
           // One Solution
           decimal numberofday = date.Day;
           decimal d = (Math.Floor(numberofday / 7)) + 1;

           if ((numberofday) % 7 == 0)
           {
              return Convert.ToInt32((d)) - 1;
           }
           return Convert.ToInt32(d);

       }

Posted 6-Feb-19 20:05pm

NayanRana

Comments

CHill60 7-Feb-19 4:50am

A word of warning - you will get a better reception when you post solutions to old posts like this if you explain a bit more about why your solution is better than the others.
Something like this would do it - "Note with the other solutions that the 7th, 14th, 21st and 28th of each month are returned as week 2, 3, 4 and 5 instead of 1, 2, 3, 4. This adjustment caters for that"

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

MT_ · Accepted Answer · 2012-11-01T02:25:00

Well,
You really don't need to write much code or do calculation for that. You can use
System.Globalization.CultureInfo.Calendar object. It has GetWeekOfYear method.

C#

System.Globalization.CultureInfo cult_info = System.Globalization.CultureInfo.CreateSpecificCulture("no");

System.Globalization.Calendar cal = cult_info.Calendar; 
    
int weekCount = cal.GetWeekOfYear(date, cult_info.DateTimeFormat.CalendarWeekRule, cult_info.DateTimeFormat.FirstDayOfWeek);

Check http://msdn.microsoft.com/en-us/library/system.globalization.calendar.getweekofyear.aspx[^]

Hope that helps. If it does then mark the answer as solution/upvote.

Thanks
Milind

Sanjay K. Gupta · Accepted Answer · 2012-11-01T01:53:00

Solution 1

DateTime dt=DateTime.Now;//yourdatetime
int weekOfMonth=(dt.Day + ((int)dt.DayOfWeek)) / 7 + 1;

Posted 1-Nov-12 1:53am

Sanjay K. Gupta

Updated 1-Nov-12 2:12am

v2

Comments

Thomas Daniels 1-Nov-12 7:55am

Good answer, +5!

OriginalGriff 1-Nov-12 8:07am

So, what week does it have December 4th this year? :laugh:

OriginalGriff 1-Nov-12 8:06am

Sorry, but that is not a good solution.
For your solution, 4th December 2012 is in week 1, where a calendar will probably put it in week 2...

Sorry, but it's a 1 from me.

Sanjay K. Gupta 1-Nov-12 8:10am

Yes, you are right.
may be the solution
(dt.Day + ((int)dt.DayOfWeek)) / 7 + 1

Zukiari 1-Nov-12 8:33am

It getting correct. Can i count the week from monday, that is, for 07-01-2013 it is in second week but 1st monday of the month. I want to get the no as 1.

Sanjay K. Gupta 1-Nov-12 8:36am

As per OriginalGriff, the first day of week may differ from culture to culture.
You can try below solution.

Zukiari 1-Nov-12 9:35am

How will I get that?

Zukiari · Accepted Answer · 2012-11-01T19:53:00

The code below give the result what I want exactly.

C#

if (dtime.Day <= 7)
        {
            count = 1;
        }
        else if (dtime.Day > 7 && dtime.Day <= 14)
        {
            count = 2;
        }
        else if (dtime.Day > 14 && dtime.Day <= 21)
        {
            count = 3;
        }
        else if (dtime.Day > 21 && dtime.Day <= 28)
        {
            count = 4;
        }
        else if (dtime.Day > 28)
        {
            count = 5;
        }

Thank You.

get week number within the month from date

5 solutions

Solution 2

Solution 1

Solution 4

Solution 3

Solution 6

Add your solution here

Preview 0