User talk:Ed Poor/holiday offset

This can all be simplified with the WEEKDAY function:


 * returns
 * returns
 * returns
 * returns

NQ = 1 + (Q-1)*7 + (N - DoW(Year,Month,1))%7;




 * 2006: May 14 =
 * 2007: May 13 =
 * 2008: May 11 =
 * 2009: May 10 =
 * 2010: May 9 =
 * 2011: May 8 =
 * 2012: May 13 =


 * First N-day: N1 = 1 + (N - DoW(Year,Month,1))%7 ;
 * 2nd N-day : N2 = 8 + (N - DoW(Year,Month,8))%7 ;
 * 3rd N-day : N3 = 15 + (N - DoW(Year,Month,15))%7 ;
 * 4th N-day : N4 = 22 + (N - DoW(Year,Month,22))%7 ;
 * 5th N-day : N5 = 29 + (N - DoW(Year,Month,29))%7.