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