Using WeekName() function and noting what dates begin and end each week
Sorry for the confusing title....
Right now I am using the WeekName() function to call the week number, and using it in a bar chart. What I'd like to do is have a pop-up text when someone mouses over a week it notes what days begin and end the week moused over.
The bar chart shows '2017/01' meaning the first week of 2017. So, I'd like 'Week is from 1-2-2017 to 1-8-2017' to pop-up as text when someone mouses over the bar.
I'm sure I have to do something with WeekStart() and WeekEnd(), but I can't get the syntax correct.