Date to Week for a month

Hi Guys

I have a date column that I want to convert to weeks

I Want it as week 1 to Week 4 only and not week 5,6 and so on

Can any one help me

Date Time

Accepted answers

All comments

@fazz111 would you want it as a rolling 7 days or a calendar week?

e.g the first was Wednesday do you want it like option 1 or 2?

day	date	week # option 1	week #option 2
Wednesday	1st	1	1
TH	2nd	1	1
Fri	3rd	1	1
Sat	4th	1	1
Sun	5th	1	1
Mon	6th	1	2
Tue	7th	1	2
Wednesday	8th	2	2

Yes so I can show a comparison between two weeks on Tableau

Week 1

Week 2

Week3

Week 4

Thats it

Ok this might help

Date to Week for a month.yxmd

Thank you so much ❤️

This helps

cool @fazz111 if this is the solution can you mark it as the solution?

Quick Links

Tags

This months top contributors

AkimasaKajitani 389

Hollingsworth 335