Help with Date and Weekday Functions

[pyrehn]

Hi there,
I need help creating a formula that calculates the date in column A, cell 4 with month and numerical day (Jun 01), and then in the rest of the column as just the numerical day (ex. 2, 3, 4, 5). Then in column B I need it to calculate the matching day of the week Sun-Sat.

So Row 1 would read - Jun-01 W
Row 2 would read - 2 Th
and so on.

I'm currently using the TEXT function to calculate column A, and am using CHOOSE + WEEKDAY and a secondary sheet to calculate the day of the week.

Is there any way to do this on a single sheet?
I've attached a copy of my spreadsheet, any help is appreciated.

Thank you so much

[AliGW]

What is wrong with the way you are doing it now? It is all on one sheet.

[AliGW]

In B4 drag copied down:

=CHOOSE(WEEKDAY(B$1+ROWS($1:1)-1), "Su", "M", "T", "W", "Th", "F", "Sa")

[Herbyb]

Enter =TEXT(($B$1+ROW(A4)-4), "MMM-DD") in cell A4 and reference cell A4 in B4....by doing this "Sheet 2" is no longer required