Business days in .net

[dd4nyc]

Hi, is there a method in C# that calculates the number of business days between given dates, like networkdays in Excel? Thank you!

[tristanreid]

public static int networkdays(DateTime a, DateTime b, List holidays)



{



int nwdays = networkdays(a, b);



int aYear = a.Year;



int bYear = b.Year;



foreach (DateTime holiday in holidays)



{



if (a.CompareTo(holiday) 0) nwdays--;



}



return nwdays;



}



public static int networkdays(DateTime a, DateTime b)



{



int totalDays = ((TimeSpan)b.Subtract(a)).Days;



TimeSpan ts = b.Subtract(a);



int aBuffer = (int)DayOfWeek.Friday - (int)a.DayOfWeek;



int bBuffer = (int)DayOfWeek.Friday - (int)b.DayOfWeek;



int nwdays = (totalDays - aBuffer + bBuffer) * 5 / 7;



if (a.DayOfWeek == DayOfWeek.Sunday) aBuffer--;



if (a.DayOfWeek == DayOfWeek.Saturday) aBuffer++;



if (b.DayOfWeek == DayOfWeek.Sunday) bBuffer--;



if (b.DayOfWeek == DayOfWeek.Saturday) bBuffer++;



return nwdays + aBuffer - bBuffer;



}

[dd4nyc]

Thank you tristanreid!