Days cars are at garage + 1 incremental

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

Which column do are you updating?
Do you have a column for the date the car was placed on the forecourt?

Windy

I'm not sure how you've done it so far, but an easy non-automatic solution would be using a formula =M4+1, double click the corner or drag down, then copy/paste the values. I'll give it some more thought.

Do you know the start date?

If you do, you can use this formula: =DAYS360(M4;TODAY())

Hi Olly,

I have just done what you have instructed and it worked. Thank you so much for all your help. It is lovely to see such a generous forum.

Rgds

Caroline