I'm using Excel 2003. I have a table of week ending dates for each week of
the year. Assume the week ends on Friday of each week. I'd like a formula
to associate each week ending date with a month of the year. But if the last
week of the month has 4 days or more, count it in the current or ending
month. If the last week has 3 or less days associate it with the upcoming
month.

For instance, week ending Friday 3-Jul-2009, has four days in June and
should be classified as a June week. Week ending 4-Sep-2009 should be
classified in September. I've researched cpearson.com and many of the
suggested functions with no luck so far.

Many Thanks