<div>
Barry, can you help with this post ?<br />
<br />
<a href="https://www.experts-exchange.com/questions/28344330/Work-day-formula.html" rel="ugc">https://www.experts-exchange.com/questions/28344330/Work-day-formula.html</a>
</div>


Barry, can you help with this post ?

https://www.experts-exchange.com/questions/28344330/Work-day-formula.html [https://www.experts-exchange.com/questions/28344330/Work-day-formula.html]

<div>
<div class="content wysiwyg-content">
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. &nbsp;Is there a way to do this?<br />
<br />
=IF(Type=&quot;MID DAY&quot;,TODAY(),((IF(WEEKDAY(<wbr />TODAY())=2<wbr />, TODAY()-3,(IF(WEEKDAY(TODA<wbr />Y())=1,TOD<wbr />AY()-2,TOD<wbr />AY()-1))))<wbr />))
</div>
</div>


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))))))

Formula for 3 day Holiday

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.