Workday Count (Function)

Function that can be used to calculate target dates, taking into account a date and hours/minutes of work, compensating for weekends, but not holidays:

Variables:

  • StartDate, a date
  • Increment, number of hours or days
  • IncrementType, hours (1) or days (2)

Return

  • Date

VBA_WorkdayCount.txt

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License