Hey folks, I was going to explain but a picture explains it better. Basically I want to see more dates, as you can see I've dropped down Cell B1 (31-Mar) to the B28 (27-Apr) Obviously if I wanted to see past 27-Apr I would just continue the drop down but I want to keep it within 28 rows and carry the dates onto cell C1-C28, D1-D28 etc, is there any way to do this using the drop down function or will I have to drop down each column individually then look date in the last row of that column and type the next date myself on the next column and drop it down?

Any help would be appreciated, if that's to hard to follow just let me know and I'll try and clear things up thanks

Capture.PNG