I don't think you can show both dates at once unless you convert it to a string.
Does showing the beginning or end of the week work instead?
It would also be helpful to see the dataset you are trying to work with -- ultimately, posting a .TWBX with your thread is the best way to get help for yourself. That way, users can open the workbook and see what you've done, as well as offer up solutions/alternatives that they can post up in response.
Thanks for your reply can you guide me to how I can change it to the start date?
Something like this? If yes, please refer the attached workbook
To achieve this you have to convert the dates into strings. I have showcased 3 different formats, you can choose the appropriate format in your workbook
Hope this helps!
If this reply helps, mark it as helpful and correct
Date_week_v10.5.twbx 55.8 KB