Weekending Date w/Less Than 3 days Assoc. with Prior Month

M

MoneyMan

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
 
T

T. Valko

Not real clear what you want.

This will return the month name based on your criteria.

A1 = some date

=TEXT(IF(DAY(A1)<=3,A1-DAY(A1),A1),"mmmm")
 
M

MoneyMan

Please excuse the lack of clarity in my question. However, you hit the nail
exactly on the head. The formula does exactly what is required.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Month days over a time period 5
Assign each week number to corresponding month of the year 5
Summing weekly values to fall into correct month 2
calculating number of days belonging to each month within a given week 2
Revenue for month 0
Summarizing multiple worksheet data 0
Display a weekending date even if there is no data 5
Search closest day in the past from today 2

Top