probably too complicated but it seems to work

=A1+(2<WEEKDAY(A1))*(7-WEEKDAY(A1)+2)+(2=WEEKDAY(A1))*(2-WEEKDAY(A1))-7


Your date in A1

Mike

"Bob" wrote:

I'm looking for formulas that will give me the first Monday and last Sunday
of a period. For example The First Monday of February 2008 would be February
4 and the last Sunday would be March 2. Add x number of days to the formulas
to give me the first Monday in April 2008 as April 7 and the last Sunday as
May 4.