Skip to main content

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

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!


Reply