=F2-DAY(F2)+8-WEEKDAY(F2-DAY(F2)) Where F2 is where you have entered the month.

http://www.excelforum.com/excel-gene...st-sunday.html

Source = Daddy Long Legs