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
