logoalt Hacker News

ecshafertoday at 1:43 PM3 repliesview on HN

When I worked in Finance our internal Date extension did actually have Workdays that took into account Stock Market and Bank Holidays.


Replies

tsukikagetoday at 3:07 PM

…now imagine a list of instruments, some of which have durations specified in days/weeks/months (problems already with the latter) and some in workdays, and the user just told your app to display it sorted by duration.

brunoarueiratoday at 3:31 PM

Me too, it was just a constant filled with bank holidays for the next 6 years

matltctoday at 3:12 PM

I tried to write this function in Power Query (Excel hell). Gave up after an hour or so.