• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 234
  • Last Modified:

Formula for 3 day Holiday

The formula below does not take into account a Holiday weekend where the Holiday is on a Monday then need for date to be the date of the Tuesday after the Holiday.  Is there a way to do this?

1 Solution
barry houdiniCommented:
It seems that your formula returns today's date if Type = "MID DAY" otherwise the previous working day. You can use WORKDAY function for that more easily and WORKDAY can also take listed holidays into account....so list your holidays somewhere on the worksheet, e.g. in H2:H10 and then use this formula


regards, barry
leezacAuthor Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now