If your assumption is true (which I don't know),
Say A1 holds 1/9/2006
=A1+MOD(7-WEEKDAY(A1,3),7)
will return first monday of september

HTH
--
AP

"Richard" a écrit dans le message de
news: ...
Does Labor day fall on the first Monday of September? If so how would you
write that formula? Thanks in advance!!!