Date Difference With Weekoff

Question

For my Asp.net C# website, I want to find the difference between two given dates from user, which should exclude second, fourth Saturday of the month and holidays. I had stored Holiday dates in table. I had used to avoid Sunday by using the following code if (date.DayOfWeek != DayOfWeek.Sunday). For example: From Date: 30/08/2018 To Date: 03/09/2018 I want answer like: Total Days - 3 From Date: 07/09/2018 To Date: 10/09/2018 I want answer like: Total Days - 2

Jenith Thakkar · Answer

namespace ConsoleAppTest { public class Program { public static void Main(string[] args) { DateTime StartdateTime = Convert.ToDateTime("2018-08-30"); DateTime EnddateTime = Convert.ToDateTime("2018-09-03"); DateTime dateToCheck = StartdateTime; List dayList = new List (); while (dateToCheck { dayList.AddRange(GetWeekDayOfMonth(dateToCheck, DayOfWeek.Saturday)); dateToCheck = dateToCheck.AddMonths(1); } //here you have to add your Holidays list in Day List dayList.Add(Convert.ToDateTime("2018-09-03")); //End Holiday List DateTime[] dateTimes = dayList.ToArray(); BusinessDaysUntil(StartdateTime, EnddateTime, dateTimes); Console.ReadLine(); } public static int BusinessDaysUntil(DateTime firstDay, DateTime lastDay, DateTime[] bankHolidays) { firstDay = firstDay.Date; lastDay = lastDay.Date; if (firstDay > lastDay) throw new ArgumentException("Incorrect last day " + lastDay); TimeSpan span = lastDay - firstDay; int businessDays = span.Days + 1; int fullWeekCount = businessDays / 7; // find out if there are weekends during the time exceedng the full weeks if (businessDays > fullWeekCount * 7) { // we are here to find out if there is a 1-day or 2-days weekend // in the time interval remaining after subtracting the complete weeks int firstDayOfWeek = (int)firstDay.DayOfWeek; int lastDayOfWeek = (int)lastDay.DayOfWeek; if (lastDayOfWeek lastDayOfWeek += 7; businessDays -= 1; } // subtract the weekends during the full weeks in the interval businessDays -= fullWeekCount + fullWeekCount; // subtract the number of bank holidays during the time interval foreach (DateTime bankHoliday in bankHolidays) { DateTime bh = bankHoliday.Date; if (firstDay --businessDays; } return businessDays; } private static IEnumerable GetWeekDayOfMonth(DateTime monthToCheck, DayOfWeek weekDayToFind) { var year = monthToCheck.Year; var month = monthToCheck.Month; var dayCount = DateTime.DaysInMonth(year, month); var daysList = Enumerable.Range(1, dayCount) .Select(day => new DateTime(year, month, day)) .Where(date => date.DayOfWeek == weekDayToFind) .ToList (); // Loop with 2 increment int lookupStart = 1; int loopCount = 0; //if (daysList[1].Day //{ // lookupStart = 2; //} for (var i = lookupStart; i { if (loopCount { yield return daysList[i]; loopCount++; } } } } } Please find a mentioned comment for holiday list . In that place you need to pass holiday list. if it is helpful for you then accept it