Help

Can I look up this week's date for a given Day of the week?

Topic Labels: Formulas
Solved
Jump to Solution
495 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Bparikh
4 - Data Explorer
4 - Data Explorer

Basically,

I have a field that lists days of the week with no reference to date. I have tasks that need to be done on a particular day. Would like to another field to automatically update itself with date of the current week for that given day. 

 

Is this possible? 

 

Thanks

1 Solution

Accepted Solutions
Sho
11 - Venus
11 - Venus

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.

See Solution in Thread

3 Replies 3
Sho
11 - Venus
11 - Venus

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. 

Exactly what I was looking for. Thanks!