overlapping calendar events on a spreadsheet

so bear with me.

just discovered insurance from mult companies in place over a varied range of dates with duplicate coverage for the same property... dont ask... =/

how do i convert a list or create a list in a basic excel spreadsheet to show overlaps.

like on my google calendar-i can have multiple events on the same day that cover teh same time ranges but maybe start and end at different times.
google just starts stacking them to the side with different colors so i can see what events overlap by where theres 1-3 events in the same 1/2 hour period..

want to do the same thing with insurance coverage dates but want it in excel(i think i do)

im a moderately average user of excel...

Take a look at this thread:

http://www.excelforum.com/excel-gene...-on-excel.html

where (from my first post) I present a calendar file that allows you to enter details of events in any order on the Activities sheet and then display those events on the (monthly) calendar sheet, where you can select the month and year of interest from drop-downs.

Hope this helps.

Pete