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

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

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

 

[Peter McNaughton]

Thanks, that fixed it nicely.