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
 
Ad

Advertisements

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.
 
Ad

Advertisements

Ad

Advertisements


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

Top