code_junkie

Adding Days to a Date but Excluding Weekends

Nov 12th, 2011
64
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.58 KB | None | 0 0
  1. var dateTime = DateTime.Now.AddBusinessDays(4);
  2.  
  3. int daysToAdd = weekDaysToAdd + ((weekDaysToAdd / 5) * 2) + (((origDate.DOW + (weekDaysToAdd % 5)) >= 5) ? 2 : 0);
  4.  
  5. public DateTime AddBusinessDays(DateTime dt, int nDays)
  6. {
  7. int weeks = nDays / 5;
  8. nDays %= 5;
  9. while(dt.DayOfWeek == DayOfWeek.Saturday || dt.DayOfWeek == DayOfWeek.Sunday)
  10. dt = dt.AddDays(1);
  11.  
  12. while (nDays-- > 0)
  13. {
  14. dt = dt.AddDays(1);
  15. if (dt.DayOfWeek == DayOfWeek.Saturday)
  16. dt = dt.AddDays(2);
  17. }
  18. return dt.AddDays(weeks*7);
  19. }
  20.  
  21. W + N % 5.
  22.  
  23. D + ((N / 5) * 7) + N % 5).
Add Comment
Please, Sign In to add comment