Hello Tableau Community,
I need some help creating a custom date. I have 12 weeks. Week 1, Week, 2, Week 3, etc. (image below). Above each week, I need a custom date. For example, above week 1, the date needs to be the Monday of the current week that you are working on. Example, I am working on the data this week, Monday was 12/3/2018. So above Week 1 will be 12/3/2018. Week 2 will be 12/3/2018 + 7 so 12/10/2018. Week 3 will be 12/10/2018 + 7 so 12/17/2018 and so forth until Week 12. (image below shows how the dates should look. Again, important that the dates need to update automatically based on the week that you are working on. For example, next week on Monday will be 12/10/2018. So above Week 1 will start of at 12/10/2018, Week 2 will be Week 1 + 7 12/17/2018, and so forth until Week 12. Thanks again for your help.
|Week 1||Week 2||Week 3||Week 4||Week 5||Week 6||Week 7||Week 8||Week 9||Week 10||Week 11||Week 12|