Generate Calendar with Specific Dates Marked

**emullark** · 01-06-2009, 06:42 PM

Hi all,

I have a spreadsheet that keeps track of my travel. Column A has the date I arrived somewhere, and Column B has the date I departed, and Column C has the name of the city I went to.

I am wondering if there is a way to generate a calendar using my list that will mark those dates. For example, a calendar for the month of June 2008 that would show I was traveling from June 3 to June 14, either by marking those dates with a different color or labeling them with the city names, or even just putting an x in the box.

I searched the forums and didn't find anything exactly like this. Thanks in advance for any ideas!

Erin

**shg** · 01-06-2009, 07:08 PM

Assuming the calendar cells contain Excel dates, you should be able to do it with a lookup formula in conditional formatting. Post a workbook.

**oldchippy** · 01-06-2009, 07:46 PM

Hi,

Welcome to the forum, how about something like this?

**emullark** · 01-07-2009, 12:57 AM

Ok, thanks! Oldchippy posted an example that I think is close to what I'm thinking, but I'm unsure how to get it to work with multiple dates or multiple months. The attachment here has some sample dates.

**emullark** · 01-07-2009, 12:58 AM

Thanks for the welcome and the idea! That is definitely on the right track of what I am thinking. I posted some sample data in response to another reply here also... I am unsure how to get it to work for multiple sets of dates...

**shg** · 01-07-2009, 01:19 AM

See attached.

**oldchippy** · 01-07-2009, 05:53 AM

Originally Posted by emullark

Thanks for the welcome and the idea! That is definitely on the right track of what I am thinking. I posted some sample data in response to another reply here also... I am unsure how to get it to work for multiple sets of dates...

Not ideal but here's one way maybe?

**shg** · 01-07-2009, 11:30 AM

Wrong attachment in last post, sorry.

**emullark** · 01-07-2009, 05:13 PM

Thank you so much! This is exactly what I was picturing.

**emullark** · 01-07-2009, 05:13 PM

Thank you so much! I am thrilled to have two different ways to lay it out and I think I will try them both and see which is easier to use in practice.

**shg** · 01-07-2009, 05:16 PM

You’re welcome. Would you please mark the thread as Solved?

Click the Edit button on your first post in the thread

Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes