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...
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.
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 ?
How do I edit the format / layout of the "Day" in the month view ?
- https://b23.tv/riHcZnL
needed to make it generate the dates ,
How about auto fill excel sheet then convert Excel sheet to .ics and use this .ics display in outlook or other canledar? - 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
jeffw9999 That 'button' used to hyperlink to a sheet called "Assignments". But in the course of this thread it got changed to "Events", but the button did not get changed with it. Right-click on the button and then 'Edit' hyperlink' and point it to "Events". You may then what ot rename the botton as well.
