# 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?

=IF(Type="MID DAY",TODAY(),((IF(WEEKDAY(TODAY())=2, TODAY()-3,(IF(WEEKDAY(TODAY())=1,TODAY()-2,TODAY()-1))))))
###### Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Commented:
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

=IF(Type="MID DAY",TODAY(),WORKDAY(TODAY(),-1,H2:H10))

regards, barry
0

Experts Exchange Solution brought to you by