Another question for you clever ones. I don't know if i'm missing something simple or not. I would like to display the weekends within a year on a grid but I want this to update itself yearly. So for example in January this year a column would display "2nd -3rd January" then "9th -10th January" in the next row down and so on. Next year the weekends will be on different dates.
Is there any way I can display the weekend dates only and importantly have it update each year with user intervention? I know I can use the Weekday function to display a number for a particular day in the year so I assume what I want to do is possible somehow.