The formula below should give you what you need.
DATEADD('week', 1, DATETRUNC('week', [Date]))-1
Oops sorry for forgetting to provide details about the version of Tableau that I am using. I really should put it in my forum signature.
Would you be able to provide this in a 10.4.1 or earlier version please?