Converting Excel Weeknum Formula to Alteryx equivalent

[niteshsharma677]

Hi Everyone,

I'm trying to convert an excel formula to Alteryx formula.

Here Final Date is created using Date1 and Date2 columns using below formula

=IF(B2<$E$2,(WEEKNUM(A2+(7*6))*7+"12/20/2021"),(WEEKNUM(A2+(7*6))*7+"12/26/2022"))

Here B2 is Date2, $E$2 is '11/21/2022' and A2 is Date 1

Date1	Date2	Final Date
8/3/2022	8/3/2022	12-Sep
3/9/2023	3/9/2023	17-Apr
6/2/2023	6/2/2023	10-Jul

Can you please help me create Final Date Field in Alteryx ?

I have attached the Excel document for reference.

Thanks,

Nitesh

[Armon24]

Hi @niteshsharma677 

Looks like @JohnJPS  found a solution to the Weenum formula: 

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Calculating-Week-Number-using-DateTime...