Group data on a weekly basis

[saachitalwar]

Hi, I have data in the form -

US	A	24-Aug-12
[Null]	B	24-Jul-25
GB	C	10/4/2024 0:00
ZA	D	10/3/2024 0:00
SE	E	24-Jun-11
[Null]	F	11/20/2024 0:00
US	G	24-Aug-12
US	H	24-Jun-03
US	i	24-Jul-19

I want to add a column that bifurcates the dates such that dates within a week are clubbed together (monday to sunday)

Thanks

[martinson · Accepted solution]

I hope you're having a great day! I have created a workflow that will give you the week number (out of 52 in a year). Let me know if you have any other questions!