MLK b-day as holiday date
Hi,
try this where a1 contains any properly formatted date.
=A1-DAY(A1)+CHOOSE(WEEKDAY(A1-DAY(A1)),22,21,20,19,18,17,23)
--
Mike
When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
"Greg" wrote:
hi,
i need a function to calculate what date would be the 3rd monday in January
for a given year. can this be done w/o arrays?
thanks
--
______
Regards,
Greg
|