Results 1 to 2 of 2

Thread: possible to have WORKDAY FUNCTION holiday range to include time stamp?
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    May 2010
    Posts
    45
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

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

    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.

  2. #2
    Board Regular James006's Avatar
    Join Date
    Apr 2009
    Posts
    3,358
    Post Thanks / Like
    Mentioned
    19 Post(s)
    Tagged
    1 Thread(s)

    Default Re: possible to have WORKDAY FUNCTION holiday range to include time stamp?

    Hello,

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

    Hope this will help

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •