OK I need a solution Without using macros (long story). I have a chart
for which I want the x axis to show dates, the maximum to be yesterday
(today()-1), stretching back 30 days but only showing weekdays,
Obviously this will update daily. Can anyone help with this?