Hi,

I was hoping somebody could help. I have 100 cars and I rent these cars to people, when somebody calls me to hire a car I will need to use an excel spreadsheet to confirm how many cars are available at any given time, my current spreadsheet has a calendar made on it and I wanted to know if I could link this calendar to a cell meaning I only need to enter a date that the car is to be hired on and it will list how many cars are available on that particular day?

Forgive my descriptive powers on this post.

My end product spreadsheet will map out all the cars registration plates on the calendar while providing me in a separate cell how many are available for any given period.

I'm trying to attach the attacvhment but this will not work nor can I screenshot this.

Any ideas?

Thanks