Custom Date

Version 1

    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.

     

    12/3/201812/10/2018
    12/17/2018
    12/24/201812/31/201801/07/201901/14/201901/21/201901/28/201902/4/201902/11/201902/18/2019
    Week 1Week 2Week 3Week 4Week 5Week 6Week 7Week 8Week 9Week 10Week 11Week 12