Export/Convert excel data to calendar

**larry108** · 03-16-2013, 08:26 PM

Hello:

I need to export an excel file with specific dates to a calendar.
I do not want to export it to google calendar or outlook, because I have to provide the calendar to my team for a combined Dashboard report.
Can I export/convert the dates to a calendar and display it on the same excel file?

Thank you.

**tgsekhar** · 03-17-2013, 03:09 AM

To my knowledge Excel do not have any calendar on its own. You may need to provide further inputs and may be a sample worksheet, so that members can attempt to help you.

**larry108** · 03-17-2013, 03:34 PM

Hi:

If I remember correctly, Excel 2007 has a developer option and I can choose Visual Basic to convert the Dates into a Calendar.
However, I am not able to use the Visual Basic due to missing steps (I guess). This is only a draft not a real business activity calendar.
Please see the enclosed draft.

Thank you.