For example, if you always display this Friday(5), the formula would look like this.
DATEADD(DATETIME_PARSE(WEEKNUM(TODAY()),"w"),5,"day")
0 is Sunday and 6 is Saturday.
For example, if you always display this Friday(5), the formula would look like this.
DATEADD(DATETIME_PARSE(WEEKNUM(TODAY()),"w"),5,"day")
0 is Sunday and 6 is Saturday.
Thank you @Sho much! This worked like a charm.
For example, if you always display this Friday(5), the formula would look like this.
DATEADD(DATETIME_PARSE(WEEKNUM(TODAY()),"w"),5,"day")
0 is Sunday and 6 is Saturday.
Exactly what I was looking for. Thanks!