Problem with Calendar Week calculation

[df]

Hello,

I have a table with Dates

2014-12-22

2014-12-29

2015-01-05

i use this formular to calculate calendarweek

DateTimeFormat([Date],"%W.%Y")

Then i used the formular DateTimeFormat(DateTimeAdd([Date],7,"days"),"%W.%Y")

But didnt worked the way i want to

My output is here

date	DateTimeFormat([Date],"%W.%Y")	DateTimeFormat(DateTimeAdd([Date],7,"days"),"%W.%Y")	https://www.timeanddate.com/date/weeknumber.html#
2014-12-22	51.2014	52.2014	52.2014
2014-12-29	52.2014	01.2015	01.2015
2015-01-05	01.2015	02.2015	02.2015
...	...	...	...
2015-12-28	52.2015	01.2016	53.2015
2016-01-04	01.2016	02.2016	01.2016

The last column is my desired output calculated with https://www.timeanddate.com/date/weeknumber.html#

Do you know how to get the output i want?

It seems like alteryx calculate calendarweek wrong befor 2016?

Is there a way to calculate it like in excel?

(attached a textfile with some dates i use)

[cmcclellan · Accepted solution]

I think this is what you're looking for:

https://community.alteryx.com/t5/Data-Preparation-Blending/Calculating-Week-Number-using-DateTimeFor...