Forum Discussion
Converting excel data into a printable calendar template
My work runs about 200 events per year. These are listed in an excel spreadsheet. However they also have a word template which has the layout of an annual calendar. This means there are months acr...
Riny_van_Eekelen thank you for the "Berlin Marathon" planner I was able to customize it for exactly what I need. Only thing how can I get Monday to be the start date and not Sunday? Any help is so appreciated!
RM2568 This may be too late for you, but to start the week on a Monday not a Sunday change as below:
Original - Week Start Sunday
=IF(WEEKDAY(DATEVALUE("1-"&WkMonth&"-"&WkYear))=COLUMN(A$2),1,IF(LEN(A5)>0,A5+1,""))
New - Week Start Monday
=IF(WEEKDAY(DATEVALUE("1-"&WkMonth&"-"&WkYear),2)=COLUMN(A$2),1,IF(LEN(A10)>0,A10+1,""))