Excel VBA Workday 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:
- Function Name: Fx_NextWorkday
- StartDate, a date
- Increment, number of hours or days
- IncrementType, hours (1) or days (2)
- Return: Date
It populates most of the Original Target Date column, I, and is built into the spreadsheet. Also, It might be inaccurate over longer time intervals, but it works in this context.
Click the download button for Excel_Fx_NextWorkday.txt...