possible to have WORKDAY FUNCTION holiday range to include time stamp?

[erickguz]

Hi.

= Workday(A1,1,[holidays])

For the "holidays" I have no problem with my list: (1/1/19, 1/21/19, 2/18/19, etc.).

However, I am making a stock market calendar with different time increments. Sometimes the market closes an hour earlier to observe the upcoming holiday. Thus instead of opening 9:30 - 16:00, the market will be open 9:30 - 15:00.

Is it possible to enter a holiday for the 12/24/19 15:00 - 16:00 hour in the WORKDAY reference, or a possible workaround?

Thank you.

 

[James006]

Hello,

You should take a look at NETWORKDAYS.INTL() function ...

Hope this will help