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

Summing weekly values to fall into correct month 2
Display a weekending date even if there is no data 5
Calculate End Date Using Start Date and No. of Days excluding specific days. 0
How to format cells to show dates as the week-ending date of that 1
Date Formula 2
how to check for days of the week 7
How to count records w/o counting duplicates by week, month, or ye 4
Add 7 days to date but also 14 days 1

Top