In this post I plan to share a trick in Jedox spreadsheet to lay out a dynamic formula driven calendar based on your input month and year value the month laid out calendar changes itself according to the week days monthly template is laid out.
The calendar is driven via another sheet in the wss, where the formulas are laid out for the monthly template to look upon according to the week day index’s.
The inspiration for me to build this calendar is partially a project requirement along with support from the following blog post laying out the same for excel.
http://chandoo.org/wp/2011/12/27/download-free-2012-calendar/
http://www.excelhero.com/blog/2010/01/live-calendar-musings.html
This is also a clear representation of the power of Jedox in terms of bringing excel to web, in its complete essence.
Download the attached wss file for yourself’s to review and feel free to ask me any relevant questions relating to the same.
Enjoy !!!
