# Thread: Help with Date and Weekday Functions

1. ## Help with Date and Weekday Functions

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

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

3. In B4 drag copied down:

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

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

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•