How to get the list of weeks for the particular month using c#?

Question

Hello, I need the list of weeks of the perticular month with from and to date of week ie. if I select March-2021 I need the list as below.. 01/03/2021 -- 07/03/2021 08/03/2021 -- 14/03/2021 15/03/2021 -- 21/03/2021 22/03/2021 -- 28/03/2021 29/03/2021 -- 31/03/2021

Piyush Pansuriya · Answer

Hi Rohan, You can use the below function public static IEnumerable GetListofWeeks( int year, int month) { var calendar = CultureInfo.CurrentCulture.Calendar; var firstDayOfWeek = CultureInfo.CurrentCulture.DateTimeFormat.FirstDayOfWeek; var weekPeriods = Enumerable.Range(1, calendar.GetDaysInMonth(year, month)) .Select(d => { var date = new DateTime(year, month, d); var weekNumInYear = calendar.GetWeekOfYear(date, CalendarWeekRule.FirstDay, firstDayOfWeek); return new { date, weekNumInYear }; }) .GroupBy(x => x.weekNumInYear) .Select(x => new { DateFrom = x.First().date, To = x.Last().date }) .ToList(); return weekPeriods; } Pass the month and year to get the list of weeks. var ListofWeeks = GetListofWeeks(DateTime.Now().Year, DateTime.Now().Month);

Rijwan Ansari · Answer

You can get this list of weeks by this function public static List GetWeeks( this DateTime month, DayOfWeek startOfWeek) { var firstOfMonth = new DateTime(month.Year, month.Month, 1); var daysToAdd = ((Int32)startOfWeek - (Int32)month.DayOfWeek) % 7; var firstStartOfWeek = firstOfMonth.AddDays(daysToAdd); var current = firstStartOfWeek; var weeks = new List (); while (current.Month == month.Month) { weeks.Add(current); current = current.AddDays(7); } return weeks; }

Satya Karki · Answer

HI, try this way DateTime reference = DateTime.Now; Calendar calendar = CultureInfo.CurrentCulture.Calendar; IEnumerable int > daysInMonth = Enumerable.Range(1, calendar.GetDaysInMonth(reference.Year, reference.Month)); List > weeks = daysInMonth.Select(day => new DateTime(reference.Year, reference.Month, day)) .GroupBy(d => calendar.GetWeekOfYear(d, CalendarWeekRule.FirstFourDayWeek, DayOfWeek.Sunday)) .Select(g => new Tuple (g.First(), g.Last())) .ToList(); weeks.ForEach(x => Console.WriteLine( "{0:MM/dd/yyyy} - {1:MM/dd/yyyy}" , x.Item1, x.Item2)); Output 10/01/2015 - 10/03/2015 10/04/2015 - 10/10/2015 10/11/2015 - 10/17/2015 10/18/2015 - 10/24/2015 10/25/2015 - 10/31/2015