Forum Discussion

Ashik008's avatar
Ashik008
Frequent Visitor
2 years ago

Current week's Tuesday date

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 exa...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.