I have set up the spreadsheet to calculate the day of the week automatically from the date entered to help prevent entry errors. I have also use the conditional fomatting capability of Excel to alternate the background color on even and odd months and turn it red if a date is out of order to help with event entry.
THE PROBLEM IS THAT WHEN IT CONVERTS THE DATE into the events.js file, some dates are correctly entered as YYYYMMDD and others are shown as DD/MM/YYYY.
I can't work out where the problem is.
You can view the EXCEL FILE at http://www.worldsplayground.com/TESTCALENDAR/LayerCalendarTemplate.xls
You can view the *.BAS file at http://www.worldsplayground.com/TESTCALENDAR/LayerCalendarScript.bas
You can view the events script file at http://www.worldsplayground.com/TESTCALENDAR/events.js