I have a board with a timeline column where I currently manually enter a week timeline based on a date. For example if the date is 27th June the timeline would be Mon 26-Jun to Sun 2-Jul. All the relevant data is imported including the date field and then I have to manually add the timeline.
I am looking for a way to automate the timeline. I need the timeline because I have forumla’s based on the timeline that calculates Week Commencing, Week, Month, Year, Year-Week, Year-Month, Year-Qtr (as image below). I need all these for the dashboard graphs.