Forum Discussion
Converting excel data into a printable calendar template
Katrina Thompson Then it's perhaps better you go for an other solution. I while ago I tweaked a rather poorly designed calendar template to do just what you have in mind. Originally a student assignment planner, but now it's a "Berlin Marathon" planner. See attached.
Riny_van_Eekelen Hello, thank you so much for the Berlin Marathon Planner, which I'm trying to use for a list of mine. I'm trying to change the starting calendar day to Monday instead of Sunday. Unfortunately it doesn't work for me, can anybody help me? The starting excel file I'm using is the Berlin Mara which was uploaded to this discussion.
CBRWPA Apart from just changing the headers, that requires a small modification to the formulas in row 6 of the Month view and (hidden) row 5 of the Week view. These use the WEEKDAY function to calculate the week day for the start of the month. The default is based on Sunday-Saturday. Adding the optional return_type number 2 will use Monday-Sunday.
See attached.
Realizing this is an old thread, this is exactly what I'm looking for. I have downloaded your Berlin Mara v2 file. Once I enable the protected view, the formula no longer works. I'm assuming because it's a different version of excel that I'm using? I have Professional 2016. Any tips to get this working for me? appreciate your time!
mlschuler The file uses functions that require MS365 or Excel 2021.
- When I click on Assignments, it gives an error "Reference isn't valid".
How do I edit the format / layout of the "Day" in the month view ?- I managed to figure out making the calendar do what I wanted it to do. I have all the time off generating to a calendar. The problem was that I was going, for example, 8/10 to 8/16 on the table and trying to get it to fill in on the calendar. I needed to make it generate the dates and then carry over the data to fill in the calendar
Riny_van_Eekelen Thank you very much, that solved it!
