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

erickguz

New Member
Joined
May 11, 2010
Messages
48
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.
 

Some videos you may like

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

James006

Well-known Member
Joined
Apr 4, 2009
Messages
3,680
Hello,

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

Hope this will help
 

Watch MrExcel Video

Forum statistics

Threads
1,095,287
Messages
5,443,584
Members
405,239
Latest member
spl

This Week's Hot Topics

Top