Excel 2007 : Want to return a value based on date range

Ok, I've searched the forums, googled it, tried several functions on my own and I just can't figure this one out.

Here's what I'd like to do and thanks in advance for any help. It will really put my mind at ease if I can get this spreadsheet working.

Basically I have various dates in a spreadsheet. If that date for example falls in between March 28th and April 3rd inclusive, I'd like to return a value of "3/28/10" which represents the particular "week of" that the particular dates falls into.

So whether the date is 3/28, 3/29, 3/30, 3/31, 4/1, 4/2, or 4/3, I'd like to return the value of 3/28. If the date is between April 4th and April 10th then I'd like to just return the value 4/10. I've tried nested ifs, various date functions, and just can't anything that works right =)

Thanks!!!!

You my friend are AWESOME!!!! I think this may become my new favorite forum =) Thanks! Thanks!! Thanks!!!