Thanks Anders; that's a new one on me! Stuart
Firstly I'd like to thank all the responders for their help. Secondly I need to apologise for the confusion I caused with the odd dates in the example...
Thanks Riny. The dates are the Friday of each week in the period under review (actually the live data shows all 52 weeks in our financial year). Your ...
Thanks Hans. I'm using 365 version 2305. The list of suppliers already exists in order of our original arrangements with them and the date of payme...
Thanks Anders; that works beautifully. The only problem is that I can't see your formula; the only thing visible in the calculated cells is "=IF(" ...
The file is now shown attached to this reply (although I thought that I did the same process in the original post!)