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