Date Difference With Weekoff

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 <= EnddateTime)

{

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 < firstDayOfWeek)

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 <= bh && bh <= lastDay)

--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 <= 9)

//{

// lookupStart = 2;

//}

for (var i = lookupStart; i < daysList.Count(); i = i + 2)

{

if (loopCount < 2)

{

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

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Jenith Thakkar8y ago
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 <= EnddateTime)
{
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 < firstDayOfWeek)
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 <= bh && bh <= lastDay)
--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 <= 9)
//{
// lookupStart = 2;
//}
for (var i = lookupStart; i < daysList.Count(); i = i + 2)
{
if (loopCount < 2)
{
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