working day, public holidays, report due dates

A

ajm

Well-known Member
Joined
Feb 5, 2003
Messages
2,005
Office Version
  1. 365
Platform
  1. Windows
Hi all, heading into the weekend and i have a last minute problem. I am tarting up a reporting schedule so the boss doesn't have to enter all the due dates of our standard reports each month. The schedule is a grid: the reports are listed down the left hand side and the day each is due is in the next column. The due day is not a date but a day past ledger close count. So Day plus 4 is the fourth working day after Close. Day +7, is seven working days past close, etc etc. The dates in the month are across the top of the sheet.

Code: 
<!-- Please do not remove this header -->
<!-- Table easily created from Excel with ASAP Utilities (http://www.asap-utilities.com)  -->
<table border="1" bordercolor="#C0C0C0" bordercolordark="#FFFFFF" cellpadding="0">
 <tr>
 <td bgcolor="#FFFFFF" align="left" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><b>May</b></font></td>
 <td bgcolor="#FFFFFF" align="right" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Month Date</font></td>
 <td bgcolor="#FFFFFF" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">26- Apr</font></td>
 <td bgcolor="#FFFFFF" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">27- Apr</font></td>
 <td bgcolor="#FFFFFF" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">28- Apr</font></td>
 <td bgcolor="#FFFFFF" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">29- Apr</font></td>
 <td bgcolor="#FFFFFF" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">30- Apr</font></td>
 <td bgcolor="#FFFFFF" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">1- May</font></td>
 <td bgcolor="#FFFFFF" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">2- May</font></td>
 <td bgcolor="#FFFFFF" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">3- May</font></td>
 <td bgcolor="#FFFFFF" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">4- May</font></td>
 <td bgcolor="#FFFFFF" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">5- May</font></td>
 <td bgcolor="#FFFFFF" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">6- May</font></td>
 <td bgcolor="#FFFFFF" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">7- May</font></td>
 <td bgcolor="#FFFFFF" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">8- May</font></td>
 <td bgcolor="#FFFFFF" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">9- May</font></td>
 <td bgcolor="#FFFFFF" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">10- May</font></td>
 </tr>
 <tr>
 <td bgcolor="#FFFFFF" align="left" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i>5</i></font></td>
 <td bgcolor="#FFFFFF" align="right" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Day</font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Thu</font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Fri</font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Sat</font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Sun</font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Mon</font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Tue</font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Wed</font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Thu</font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Fri</font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Sat</font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Sun</font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Mon</font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Tue</font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Wed</font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Thu</font></td>
 </tr>
 <tr>
 <td bgcolor="#FFFFFF" align="right" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><b>Working Day</b></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><b>-3</b></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><b>-2</b></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><b></b></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><b></b></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><b>-1</b></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><b>1</b></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><b>2</b></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><b>3</b></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><b>4</b></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><b></b></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><b></b></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><b></b></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><b>5</b></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><b>6</b></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><b>7</b></font></td>
 </tr>
 <tr>
 <td bgcolor="#D9D9D9" align="left" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i>Recurrent weekly reporting</i></font></td>
 <td bgcolor="#D9D9D9" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#D9D9D9" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#D9D9D9" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#D9D9D9" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#D9D9D9" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#D9D9D9" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#D9D9D9" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#D9D9D9" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#D9D9D9" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#D9D9D9" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#D9D9D9" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#D9D9D9" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#D9D9D9" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#D9D9D9" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#D9D9D9" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#D9D9D9" align="right" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 </tr>
 <tr>
 <td bgcolor="#FFFFFF" align="left" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Report 1</font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Monday</font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i>X</i></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i>X</i></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 </tr>
 <tr>
 <td bgcolor="#FFFFFF" align="left" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Report 2</font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Monday</font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i>X</i></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i>X</i></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 </tr>
 <tr>
 <td bgcolor="#FFFFFF" align="left" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Report 3</font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Monday</font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i>X</i></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i>X</i></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 </tr>
 <tr>
 <td bgcolor="#FFFFFF" align="left" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Report 4</font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Monday</font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i>X</i></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i>X</i></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 </tr>
 <tr>
 <td bgcolor="#FFFFFF" align="left" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Report 5</font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Monday</font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i>X</i></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i>X</i></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 </tr>
 <tr>
 <td bgcolor="#FFFFFF" align="left" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Report 6</font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Monday</font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><i></i></font></td>
 </tr>
</table>








On a second tab, i have worked out the Month Ending days of importance, Day -3 to Day +13 for each month for the next year. The months are on the left in Column C and the Working Day Count is along the top in Row 3.

Code: 
<!-- Please do not remove this header -->
<!-- Table easily created from Excel with ASAP Utilities (http://www.asap-utilities.com)  -->
<table border="1" bordercolor="#C0C0C0" bordercolordark="#FFFFFF" cellpadding="0">
 <tr>
 <td bgcolor="#FFFFFF" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Working Day Count for Calculations</font></td>
 <td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
 <td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">-2</font></td>
 <td bgcolor="#FFFFFF" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">-1</font></td>
 <td bgcolor="#FFFFFF" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">0</font></td>
 <td bgcolor="#FFFFFF" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">1</font></td>
 <td bgcolor="#FFFFFF" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">2</font></td>
 <td bgcolor="#FFFFFF" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">3</font></td>
 <td bgcolor="#FFFFFF" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">4</font></td>
 </tr>
 <tr>
 <td bgcolor="#FFFFFF" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Actual Work Day count</font></td>
 <td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
 <td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
 <td bgcolor="#FFFFFF" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">-3</font></td>
 <td bgcolor="#FFFFFF" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">-2</font></td>
 <td bgcolor="#FFFFFF" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">-1</font></td>
 <td bgcolor="#FFFFFF" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">1</font></td>
 <td bgcolor="#FFFFFF" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">2</font></td>
 <td bgcolor="#FFFFFF" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">3</font></td>
 <td bgcolor="#FFFFFF" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">4</font></td>
 </tr>
 <tr>
 <td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
 <td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
 <td bgcolor="#FFFFFF" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Month</font></td>
 <td bgcolor="#FFFFFF" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Day -3</font></td>
 <td bgcolor="#FFFFFF" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Day -2</font></td>
 <td bgcolor="#FFFFFF" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Day -1</font></td>
 <td bgcolor="#FFFFFF" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Day 1</font></td>
 <td bgcolor="#FFFFFF" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Day 2</font></td>
 <td bgcolor="#FFFFFF" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Day 3</font></td>
 <td bgcolor="#FFFFFF" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Day 4</font></td>
 </tr>
 <tr>
 <td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">2018</font></td>
 <td rowspan="12" bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><b>2018</b></font></td>
 <td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">January</font></td>
 <td bgcolor="#FFFFFF" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Thu, 28-Dec-17</font></td>
 <td bgcolor="#FFFFFF" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Fri, 29-Dec-17</font></td>
 <td bgcolor="#FFFFFF" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Sun, 31-Dec-17</font></td>
 <td bgcolor="#FFFFFF" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><b>Tue, 02-Jan-18</b></font></td>
 <td bgcolor="#FFFFFF" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Wed, 03-Jan-18</font></td>
 <td bgcolor="#FFFFFF" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Thu, 04-Jan-18</font></td>
 <td bgcolor="#FFFFFF" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Fri, 05-Jan-18</font></td>
 </tr>
 <tr>
 <td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">2018</font></td>
 <td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">February</font></td>
 <td bgcolor="#FFFFFF" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Mon, 29-Jan-18</font></td>
 <td bgcolor="#FFFFFF" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Tue, 30-Jan-18</font></td>
 <td bgcolor="#FFFFFF" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Wed, 31-Jan-18</font></td>
 <td bgcolor="#FFFFFF" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><b>Thu, 01-Feb-18</b></font></td>
 <td bgcolor="#FFFFFF" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Fri, 02-Feb-18</font></td>
 <td bgcolor="#FFFFFF" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Mon, 05-Feb-18</font></td>
 <td bgcolor="#FFFFFF" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Tue, 06-Feb-18</font></td>
 </tr>
 <tr>
 <td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">2018</font></td>
 <td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">March</font></td>
 <td bgcolor="#FFFFFF" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Mon, 26-Feb-18</font></td>
 <td bgcolor="#FFFFFF" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Tue, 27-Feb-18</font></td>
 <td bgcolor="#FFFFFF" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Wed, 28-Feb-18</font></td>
 <td bgcolor="#FFFFFF" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><b>Thu, 01-Mar-18</b></font></td>
 <td bgcolor="#FFFFFF" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Fri, 02-Mar-18</font></td>
 <td bgcolor="#FFFFFF" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Mon, 05-Mar-18</font></td>
 <td bgcolor="#FFFFFF" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Tue, 06-Mar-18</font></td>
 </tr>
 <tr>
 <td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">2018</font></td>
 <td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">April</font></td>
 <td bgcolor="#FFFFFF" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Wed, 28-Mar-18</font></td>
 <td bgcolor="#FFFFFF" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Thu, 29-Mar-18</font></td>
 <td bgcolor="#FFFFFF" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Sat, 31-Mar-18</font></td>
 <td bgcolor="#FFFFFF" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><b>Tue, 03-Apr-18</b></font></td>
 <td bgcolor="#FFFFFF" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Wed, 04-Apr-18</font></td>
 <td bgcolor="#FFFFFF" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Thu, 05-Apr-18</font></td>
 <td bgcolor="#FFFFFF" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Fri, 06-Apr-18</font></td>
 </tr>
 <tr>
 <td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">2018</font></td>
 <td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">May</font></td>
 <td bgcolor="#FFFFFF" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Thu, 26-Apr-18</font></td>
 <td bgcolor="#FFFFFF" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Fri, 27-Apr-18</font></td>
 <td bgcolor="#FFFFFF" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Mon, 30-Apr-18</font></td>
 <td bgcolor="#FFFFFF" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><b>Tue, 01-May-18</b></font></td>
 <td bgcolor="#FFFFFF" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Wed, 02-May-18</font></td>
 <td bgcolor="#FFFFFF" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Thu, 03-May-18</font></td>
 <td bgcolor="#FFFFFF" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Fri, 04-May-18</font></td>
 </tr>
 <tr>
 <td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">2018</font></td>
 <td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">June</font></td>
 <td bgcolor="#FFFFFF" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Tue, 29-May-18</font></td>
 <td bgcolor="#FFFFFF" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Wed, 30-May-18</font></td>
 <td bgcolor="#FFFFFF" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Thu, 31-May-18</font></td>
 <td bgcolor="#FFFFFF" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><b>Fri, 01-Jun-18</b></font></td>
 <td bgcolor="#FFFFFF" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Mon, 04-Jun-18</font></td>
 <td bgcolor="#FFFFFF" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Tue, 05-Jun-18</font></td>
 <td bgcolor="#FFFFFF" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Wed, 06-Jun-18</font></td>
 </tr>
 <tr>
 <td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">2018</font></td>
 <td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">July</font></td>
 <td bgcolor="#FFFFFF" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Thu, 28-Jun-18</font></td>
 <td bgcolor="#FFFFFF" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Fri, 29-Jun-18</font></td>
 <td bgcolor="#FFFFFF" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Sat, 30-Jun-18</font></td>
 <td bgcolor="#FFFFFF" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><b>Mon, 02-Jul-18</b></font></td>
 <td bgcolor="#FFFFFF" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Tue, 03-Jul-18</font></td>
 <td bgcolor="#FFFFFF" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Wed, 04-Jul-18</font></td>
 <td bgcolor="#FFFFFF" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Thu, 05-Jul-18</font></td>
 </tr>
 <tr>
 <td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">2018</font></td>
 <td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">August</font></td>
 <td bgcolor="#FFFFFF" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Fri, 27-Jul-18</font></td>
 <td bgcolor="#FFFFFF" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Mon, 30-Jul-18</font></td>
 <td bgcolor="#FFFFFF" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Tue, 31-Jul-18</font></td>
 <td bgcolor="#FFFFFF" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><b>Wed, 01-Aug-18</b></font></td>
 <td bgcolor="#FFFFFF" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Thu, 02-Aug-18</font></td>
 <td bgcolor="#FFFFFF" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Fri, 03-Aug-18</font></td>
 <td bgcolor="#FFFFFF" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Mon, 06-Aug-18</font></td>
 </tr>
 <tr>
 <td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">2018</font></td>
 <td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">September</font></td>
 <td bgcolor="#FFFFFF" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Wed, 29-Aug-18</font></td>
 <td bgcolor="#FFFFFF" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Thu, 30-Aug-18</font></td>
 <td bgcolor="#FFFFFF" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Fri, 31-Aug-18</font></td>
 <td bgcolor="#FFFFFF" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><b>Mon, 03-Sep-18</b></font></td>
 <td bgcolor="#FFFFFF" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Tue, 04-Sep-18</font></td>
 <td bgcolor="#FFFFFF" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Wed, 05-Sep-18</font></td>
 <td bgcolor="#FFFFFF" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Thu, 06-Sep-18</font></td>
 </tr>
 <tr>
 <td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">2018</font></td>
 <td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">October</font></td>
 <td bgcolor="#FFFFFF" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Thu, 27-Sep-18</font></td>
 <td bgcolor="#FFFFFF" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Fri, 28-Sep-18</font></td>
 <td bgcolor="#FFFFFF" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Sun, 30-Sep-18</font></td>
 <td bgcolor="#FFFFFF" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><b>Tue, 02-Oct-18</b></font></td>
 <td bgcolor="#FFFFFF" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Wed, 03-Oct-18</font></td>
 <td bgcolor="#FFFFFF" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Thu, 04-Oct-18</font></td>
 <td bgcolor="#FFFFFF" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Fri, 05-Oct-18</font></td>
 </tr>
 <tr>
 <td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">2018</font></td>
 <td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">November</font></td>
 <td bgcolor="#FFFFFF" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Mon, 29-Oct-18</font></td>
 <td bgcolor="#FFFFFF" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Tue, 30-Oct-18</font></td>
 <td bgcolor="#FFFFFF" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Wed, 31-Oct-18</font></td>
 <td bgcolor="#FFFFFF" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><b>Thu, 01-Nov-18</b></font></td>
 <td bgcolor="#FFFFFF" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Fri, 02-Nov-18</font></td>
 <td bgcolor="#FFFFFF" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Mon, 05-Nov-18</font></td>
 <td bgcolor="#FFFFFF" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Tue, 06-Nov-18</font></td>
 </tr>
 <tr>
 <td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">2018</font></td>
 <td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">December</font></td>
 <td bgcolor="#FFFFFF" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Wed, 28-Nov-18</font></td>
 <td bgcolor="#FFFFFF" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Thu, 29-Nov-18</font></td>
 <td bgcolor="#FFFFFF" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Fri, 30-Nov-18</font></td>
 <td bgcolor="#FFFFFF" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><b>Mon, 03-Dec-18</b></font></td>
 <td bgcolor="#FFFFFF" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Tue, 04-Dec-18</font></td>
 <td bgcolor="#FFFFFF" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Wed, 05-Dec-18</font></td>
 <td bgcolor="#FFFFFF" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Thu, 06-Dec-18</font></td>
 </tr>
</table>



I have used a simple If statement to identify each Monday. (=IF(LEFT($B7,3)=G$4,"X","")) where Column B contains the day due, and row 4 the day of the month. What formula can I use to accommodate public holidays. In the top screen shot, Monday the 7th May is a Public Holiday. I need the formula to skip this day and show the reports due on the next working day.
 

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK
Sort by date Sort by votes
You could create a column with all your working days in the year (in a separate, hidden tab would be my preference). And you include a VLOOKUP in your formula stating that, if the day is found in this column, to add 1. Hope this helps.
 
Upvote 0
Thanks for your response Alice. This could work.The issue with this approach is when there are concurrent public holidays, such as Easter and Christmas. Mind you, there are only a couple of those to worry about.
 
Upvote 0
Happy to help :) Not sure what you mean about Easter being a concurrent public holiday... Could you be more specific? Do you mean that it has several days? If yes, I once split the holiday into days: Easter Day 1, Easter Day 2 etc.
 
Upvote 0
You must log in or register to reply here.

Similar threads

C
  • Question
Picture won't paste in cell overlay
Replies
0
Views
67
Cerka
C
C
  • Solved
Excel 2016 32bit VBA Pulling info from Website to Sheet
Replies
2
Views
1K
CrashOD
C
E
  • Question
Adding a custom message.
Replies
1
Views
429
Micron
M
A
  • Question
VBA - Automatically Break the Line in HTML format.
Replies
7
Views
1K
Attrazion
A
E
  • Question
Query in excel to Outlook mail take rows with name until next name
Replies
0
Views
349
esben
E

Forum statistics

Threads
1,214,950
Messages
6,122,428
Members
449,083
Latest member
Ava19

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top