Excel Calendar

[emilyp123]

Hi All,

I have an Excel spreadsheet I use for my small vehicle hire business. In one column I have the date the vehicle is hired from and in another column I have the date the vehicle is hired to.

I was wondering how do I link this to a calendar in Excel so it automatically blocks/shades out the dates the vehicle is on hire for. I currently have 2 vehicles so I would want it that when one vehicle is on hire, it blocks it out on the calendar in one colour and then another colour for the other vehicle.

Please can someone help me with formulas I need etc?

Thanks Emily

[Pete_UK]

I can set this up for you, but it would help if you attached a sample workbook so I can see how your existing data is laid out. To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

Do you have particular names for the cars, rather than car1 and car2?

Pete

[emilyp123]

Hi Pete,

Thank you for your help. I have attached a template file of how I would like it but I can't see where it is, have you got it?

If you look on the calendar for July and October, you can see where I have blocked out dates in yellow and green, I have done this manually but I would like it so it does it automatically when I input dates on to the 'Burstner' or 'Swift' spreadsheet. Is that possible?

I want to keep it quite simple because none of us are the best on Excel!

Thanks,
Emily

[Pete_UK]

Emily (my daughter's name),

I presume Burstner and Swift refer to the two cars - have you thought abut having the booking details in one sheet, with a column to record which car the booking relates to?

Also, you show individual sheets for each month - you could just have one calendar sheet that covers one month, and you select the month and year from drop-downs. Does this sound okay to you?

Pete

[emilyp123]

Emily (my daughter's name),

I presume Burstner and Swift refer to the two cars - have you thought abut having the booking details in one sheet, with a column to record which car the booking relates to?

Also, you show individual sheets for each month - you could just have one calendar sheet that covers one month, and you select the month and year from drop-downs. Does this sound okay to you?

Pete

Hi Pete,

Yes that would be ok to put them both on one sheet and the calendar on another with all months on. We plan on getting a few more vehicles over the next 12-24 months so it will probably be better to have them all on one sheet.

Thanks, Emily

[Pete_UK]

Hi Emily,

I've been working on this off and on today, but it's too hot to spend a lot of time at the computer - I'll try and get something to you tomorrow.

Pete

[CHAARDY]

Hi All,

New to this forum. I've downloaded one or two of the examples above and have tried to replicate this by autofilling a calendar with classes I would teach on the days and periods I would thus teach them. I can't work out how to do the latter...
If someone could advise, that would be brilliant.

I think I've attached the file... if necessary :)

Richard

[Pete_UK]

Hi Richard,

welcome to the Forum.

Unfortunately, you have broken one of the Forum Rules (which can be seen on the top menu at the top of the screen). Rule 02 says that you shouldn't hijack someone else's thread - start one of your own, with a link back to this thread if you think it is relevant.

Pete