datetime - Calculate week of month in .NET

Question

Do the .NET libraries have an easy way of returning the week number for a given date? For example, input of Year = 2010, Month = 1, Day = 25, should output 5 for the week number.

Closest I found was Calendar.GetWeekOfYear, which is almost there.

Java has a date string format "W" which returns week in month but I can't see anything equivalent in .NET.

question from:https://stackoverflow.com/questions/2136487/calculate-week-of-month-in-net

Answer 1

There is no built in way to do this but here is an extension method that should do the job for you:

static class DateTimeExtensions {
    static GregorianCalendar _gc = new GregorianCalendar();
    public static int GetWeekOfMonth(this DateTime time) {
        DateTime first = new DateTime(time.Year, time.Month, 1);
        return time.GetWeekOfYear() - first.GetWeekOfYear() + 1;
    }

    static int GetWeekOfYear(this DateTime time) {
        return _gc.GetWeekOfYear(time, CalendarWeekRule.FirstDay, DayOfWeek.Sunday);
    }
}

Usage:

DateTime time = new DateTime(2010, 1, 25);
Console.WriteLine(time.GetWeekOfMonth());

Output:

5

You can alter GetWeekOfYear according to your needs.