Menu
Exactly as it says on the tin, I just need the most efficient way of counting weeks (i.e. 7-day spans, not calendar weeks) between two dates in C#.
218
To determine how many weeks elapsed between two dates, we can use a simple formula to find the number of days between the dates, then divide by 7. The formula will return a decimal number.
To find out how many weeks there are between two dates, you can use the DATEDIF function with "D" unit to return the difference in days, and then divide the result by 7. Where A2 is the start date and B2 is the end date of the period you are calculating.
Now we can use the ChronoUnit enum to calculate elapsed weeks. long weeks = ChronoUnit. WEEKS. between( startZdt , stopZdt );
Get the number of days and divide by 7.
int weeks = (date1 - date2).TotalDays / 7; You may well have a remainder of up to 6 days that will not be included in the number of weeks.
159
I assume you want to get this on the basis of the Calender. For this you need System.Globalization
DateTime date1 = DateTime.Now; DateTimeFormatInfo dinfo = DateTimeFormatInfo.CurrentInfo; dinfo.Calendar.GetWeekOfYear(date1, CalendarWeekRule.FirstFullWeek, DayOfWeek.Monday) Based on your need you have to set the Calender week rule and the first day of the week.
This gives you a week number for the calender. you can get the same for your other date, the difference is your weeks count
Hope this helps you.
38
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
