How to receive the same week number as is in excel ?

Hi,

I was trying few solutions but still did not receive the result I am looking for.

I have a report with data from few years.

We want to receive comparison week to week for each calendar year.

As previously we used excel to count number of weeks I would like to receive now the same week number as it appears in excel.

I was trying to use Week number formula, week number + 1 and 2 more 'tricks' I found here. But still do not receive the same results.

Do you have any advice what to try?

Thanks in advance for your help!

Accepted answers

Have you tried the DateTimeParse() or DateTimeFormat() functions?

Could you share some simple data with the expected result in order to help 🙂

I had some issue using datetimediff with weeks I changed to days in order to flag weeks

DateTimeDiff([EndDate],[StartDate],"days")

Hope that helps,

Regards,

Application Date and Time	Week Alteryx	Week Excel	match?	I would like to receive the same Week nr in Alteryx as I receive in XLSX
01.01.2015 00:00	1	1	yes
02.01.2015 00:00	1	1	yes
03.01.2015 00:00	1	1	yes
04.01.2015 00:00	1	2	no
05.01.2015 00:00	1	2	no
06.01.2015 00:00	1	2	no
07.01.2015 00:00	1	2	no
08.01.2015 00:00	2	2	yes
09.01.2015 00:00	2	2	yes
10.01.2015 00:00	2	2	yes
11.01.2015 00:00	2	3	no
12.01.2015 00:00	2	3	no
13.01.2015 00:00	2	3	no
14.01.2015 00:00	2	3	no
15.01.2015 00:00	3	3	yes
16.01.2015 00:00	3	3	yes
17.01.2015 00:00	3	3	yes
18.01.2015 00:00	3	4	no
19.01.2015 00:00	3	4	no
20.01.2015 00:00	3	4	no
02.03.2019 21:44	9	9	yes
02.03.2019 22:30	9	9	yes
02.03.2019 22:32	9	9	yes
02.03.2019 22:34	9	9	yes
02.03.2019 22:43	9	9	yes
02.03.2019 23:25	9	9	yes
02.03.2019 23:31	9	9	yes
02.03.2019 23:31	9	9	yes
02.03.2019 23:40	9	9	yes
03.03.2019 00:08	9	10	no
03.03.2019 00:14	9	10	no
03.03.2019 00:25	9	10	no
03.03.2019 00:29	9	10	no
03.03.2019 00:34	9	10	no
03.03.2019 00:42	9	10	no
03.03.2019 01:04	9	10	no
03.03.2019 01:17	9	10	no
03.03.2019 02:57	9	10	no
03.03.2019 03:28	9	10	no
03.03.2019 03:39	9	10	no