Hello @anasia,
Custom date format and formatDate use different formats.
QuickSight does not support yet extracting the week, if you are looking for something like that, this community post has a formula to return the week from a date.
Hope this helps!
Kind regards, Andres.