Creating Vertical Chronological List Of Weekends And Month Ends?

I need to create a report on each friday as well as on every last workday of a month. I have to display both weekly and monthly data on the same graphs and I always arranged the week ends and month ends myself, but this is taking a lot of time.

So I need a chronological list of of week numbers and month names based on the date of Friday of a week or last workday of a month.

Input:
A1 - either month name ("MMM", Jul, Aug, Sep) or week number (1-52)
A2 - year number (2014)

Output:
For example, for 30 in A1 and 2014 in A2 it should look like this:

BD
BE
BF
BG
BH
BI
BJ
BK
BL
BM

1
May
23
24
25
26
Jun
27
28
29
30

And this should strech back all the way back to B1 in which I need to have 31.

Note if a month ends on last workday of a month the week number should come first and month name second.