Current week's Tuesday date

[Ashik008]

Hi all,

I need help with date column .

I have a date column which shows current date using Today() function . I need to create another column which showing the Tuesday' date of that week .

for example if today is 6/23/2024, column should show 6/25/2024 and it changes when next week starts 

eg when6/30/2024 starts , new column changes to 7/2/2024 like that .please help.

[v-xinruzhu-msft]

Hi,

Thanks for the solution @ajohnso2  provided, and i want to offer some more infotmation for user to refer to.
hello @Ashik008 , you can refer to the following code.

Based on the today column, create a new calculated column.

Column 2 = var a=WEEKDAY([Today],1)
return [Today]-a+3

Output

And you can refer to the attachment

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Ashik008]

Hi all,

I need help with date column .

I have a date column which shows current date using Today() function . I need to create another column which showing the Tuesday' date of that week .

for example if today is 6/23/2024, column should show 6/25/2024 and it changes when next week starts 

eg when6/30/2024 starts , new column changes to 7/2/2024 like that .please help

[ajohnso2]

You really should look into having a date dimension if you dont already, this would be the easiest option.

For example, if you had a column holding the day of week number - you would basically have your answer