StartDate < 20th Dec. StartDate + offset > 20th Dec.

  • Thread starter Thread starter Peter McNaughton
  • Start date Start date
P

Peter McNaughton

Hi,
I need to determine where 2 dates are either side of 20th Dec in
AnyYear
Reason
Tradesmen in NZ usually take all their holidays between 20th Dec and
approx 20th Jan.

I have a worksheet with a named range of "StartDate", and a series of
rows with numbers representing the offset from the start date.

If the StartDate <20th Dec in any year and the StartDate + offset
=20th Dec then I will add an additional 28 days (4 weeks)
Click to expand...

Example (approx)
StartDate 1-Dec-2003
offset 10 = 11-Dec-2003
20 = 20-Jan-2004
30 = 30-Jan-2004
40 = 09-Feb-2004


Thanks in advance
Peter
 
Back
Top