Good Morning all,

I have inherited a spreadsheet for the company I have started working for. They have a list of vehicles on the forecourt that are available to sell. Each vehicle is obviously there for different amount of days. Every day I have to add +1 to each day a vehicle is there. It is tedious and time consuming and I am trying to work a formula to add a day to each vehicle and update it everyday. These vehicles are listed in year order so I cannot change that side of it.

Any help on this would be appreciated. I have attached a print screen of the spreadsheet and the cell in red is the one I need to add a day to every day.

Thanks so much.

Rgds

CarolineCar Print Screen.jpg