Requesting help, I need the week number based on start of the month

[Manjari]

Hi All, 

Requesting help, I need the week number based on start of the month in Alteryx

Date	Week day	Week number
01-02-2022	Tuesday	1
02-02-2022	Wednesday	1
03-02-2022	Thursday	1
04-02-2022	Friday	1
05-02-2022	Saturday	1
06-02-2022	Sunday	2
07-02-2022	Monday	2
08-02-2022	Tuesday	2
09-02-2022	Wednesday	2
10-02-2022	Thursday	2
11-02-2022	Friday	2
12-02-2022	Saturday	2
13-02-2022	Sunday	3
14-02-2022	Monday	3
15-02-2022	Tuesday	3
16-02-2022	Wednesday	3
17-02-2022	Thursday	3
18-02-2022	Friday	3
19-02-2022	Saturday	3
20-02-2022	Sunday	4
21-02-2022	Monday	4
22-02-2022	Tuesday	4
23-02-2022	Wednesday	4
24-02-2022	Thursday	4
25-02-2022	Friday	4
26-02-2022	Saturday	4
27-02-2022	Sunday	5
28-02-2022	Monday	5
01-03-2022	Tuesday	1
02-03-2022	Wednesday	1
03-03-2022	Thursday	1
04-03-2022	Friday	1

[messi007 · Accepted solution]

@Manjari,

Please see below how you can do it : 

Attached the workflow,

Regards,

[atcodedog05 · Accepted solution]

Hi @Manjari 

Here is how you can do it.

Workflow:

Hope this helps : )

[Qiu · Accepted solution]

@Manjari 
I have to assume your date starts from the first day of the month.

[RolandSchubert · Accepted solution]

Hi @Manjari ,

can be done using Formula tool and DateTime functions.

Let me know if it works for you.

Best,

Roland

[Manjari]

@RolandSchubert , @Qiu , @atcodedog05  @messi007 : Thank you all for taking out time and helping me out. I completed an transformation project because of you guys. :)

[messi007]

@Manjari,

Happy to help :)

Regards,

[atcodedog05]

Happy to help : ) @Manjari 

Cheers and have a nice day!

[Qiu]

@Manjari 
Glad to help and thank you for the accept mark.