.NET Date Compare: Count the amount of working days since a date?

by

This’ll do what you want it to. It should be easy enough to convert to VB.NET, it’s been too long for me to be able to do it though.

DateTime start = DateTime.Now;
DateTime end = start.AddDays(9);
IEnumerable<DateTime> holidays = new DateTime[0];

// basic data
int days = (int)(end - start).TotalDays;
int weeks = days / 7;

// check for a weekend in a partial week from start.
if (7- (days % 7) <= (int)start.DayOfWeek)
    days--;
if (7- (days % 7) <= (int)start.DayOfWeek)
    days--;

// lose the weekends
days -= weeks * 2;

foreach (DateTime dt in holidays)
{
    if (dt > start && dt < end)
        days--;
}

More Related Contents:

  1. What is the best algorithm for overriding GetHashCode?
  2. Comparing two collections for equality irrespective of the order of items in them
  3. .NET – How can you split a “caps” delimited string into an array?
  4. Create a hashcode of two numbers
  5. DateTime.Now vs. DateTime.UtcNow
  6. .net ORM Comparison [closed]
  7. Is there an easy way in .NET to get “st”, “nd”, “rd” and “th” endings for numbers? [duplicate]
  8. Counting bits set in a .Net BitArray Class
  9. For Each Loop in Visual Basic: IndexOutOfRangeException [closed]
  10. When should I use a struct instead of a class?
  11. How to populate a WPF grid based on a 2-dimensional array
  12. Difference between LoadFile and LoadFrom with .NET Assemblies?
  13. XML – Data At Root Level is Invalid
  14. How do you loop through currently loaded assemblies?
  15. When should I deploy my assemblies into the GAC?
  16. NetworkStream.ReadAsync with a cancellation token never cancels
  17. How can I make a single event handler handle ALL Button.Click events?
  18. Dependency Injection in .NET with examples?
  19. .NET Config Files configSource outside the application directory folder
  20. WPF Handedness with Popups
  21. Custom MVVM implementation Vs. PRISM
  22. When is an HTTP response finished?
  23. Start a Task in the Form Shown event
  24. Troubleshooting .NET “Fatal Execution Engine Error”
  25. How do I test an async method with NUnit (or possibly with another framework)?
  26. Ensuring that things run on the UI thread in WPF
  27. Nested/Child TransactionScope Rollback
  28. Regular expression to find all table names in a query
  29. How to serialize a large graph of .NET objects into a SQL Server BLOB without creating a large buffer?
  30. Best way to detect a release build from a debug build? .net

Leave a Comment