XLA routines: EE_FirstBusinessDayOfMonth

use EE_FirstBusinessDayOfMonth to find the first business day of the month that the date you are passing is in
Function EE_FirstBusinessDayOfMonth(dt As Date, rngHolidays As range) As Date '- as above but rolls to the next business day if the first bus day is a hol '- also takes a range with the holiday calendar 'http://excelexperts.com/xla-routines-eeFirstBusinessDayOfMonth for updates on this function If EE_IsBusinessDay(rngHolidays, EE_FirstDayOfMonth(dt)) Then EE_FirstBusinessDayOfMonth = EE_FirstDayOfMonth(dt) Else EE_FirstBusinessDayOfMonth = EE_NextBusinessDay(rngHolidays, EE_FirstDayOfMonth(dt)) End If End Function
»
- Nick's blog
- Login or register to post comments
- 2145 reads
Recent comments
6 years 3 weeks ago
6 years 41 weeks ago
7 years 1 week ago
7 years 4 weeks ago
7 years 5 weeks ago
7 years 10 weeks ago
7 years 18 weeks ago
7 years 19 weeks ago
7 years 19 weeks ago
7 years 19 weeks ago