Help with Date and Weekday Functions

pyrehn

New member
Joined
May 18, 2022
Messages
1
Reaction score
0
Points
0
Excel Version(s)
Excel 365 MSO
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
 

Attachments

  • TEST - Schedule.xlsx
    15.1 KB · Views: 6
What is wrong with the way you are doing it now? It is all on one sheet.
 
In B4 drag copied down:

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

Attachments

  • TEST - Schedule AliGW.xlsx
    15.1 KB · Views: 1
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
 
Back
Top