what do you mean by weeks should be in 1-6 days that means you don't want to calculate sunday or saturday in this case you need to use datediff function with combination of another function. DATEDIFF('week',[Opened],TODAY()) -
with this all Sundays will go from your logic... so that you will get exact number of days... if you want to remove saturdays also then use one more minus and add Saturday datediff function same like sunday... good luck
Here i'm not Pulling data into tableau.
I want to create a calculation by using parameter.
In this parameter having start date and end date.
By using above parameter i want to calculate Number of weeks in the month and Week number.