Forum Discussion
date display
Trankil Thanks for the link. Have looked at the template and now dare to say that I consider it totally useless. It's no better, and probably worse, than just writing your appointments in a paper calendar. All that this template allows you to do is set the start of the day (C2), the time interval between calendar entries (E2) and the data for the first day in the week (G2). Now, the real dumb thing with this template is that G2 contains the formula =TODAY(). It suggests that the schedule is dynamic in some way, automatically updating something every day. Unfortunately, it's not. As you noted yourself, the calendar entries are stuck in a cell and will not move with the day of the week or time of the time when the settings in the above-mentioned cells change. So, If you insist on using the template that I amended for you earlier, you need to set the three cells mentioned above first and get rid of the TODAY formula. Just type the date you want the calendar to start with. And then start entering your appointments/tasks. For every new period, you need to empty the calendar and start from scratch.
But, why not use the calendar function that is built-in into your computer or one of many that can be found on-line. Then you can enter appointments, tasks, whatever. Keep track of history and view/report on whatever period (day, week, month, year) you are interested in.
thank you for your reply. here is the link to the english version :
https://templates.office.com/en-us/daily-appointment-calendar-week-view-tm00000044
Trankil Thanks for the link. Have looked at the template and now dare to say that I consider it totally useless. It's no better, and probably worse, than just writing your appointments in a paper calendar. All that this template allows you to do is set the start of the day (C2), the time interval between calendar entries (E2) and the data for the first day in the week (G2). Now, the real dumb thing with this template is that G2 contains the formula =TODAY(). It suggests that the schedule is dynamic in some way, automatically updating something every day. Unfortunately, it's not. As you noted yourself, the calendar entries are stuck in a cell and will not move with the day of the week or time of the time when the settings in the above-mentioned cells change. So, If you insist on using the template that I amended for you earlier, you need to set the three cells mentioned above first and get rid of the TODAY formula. Just type the date you want the calendar to start with. And then start entering your appointments/tasks. For every new period, you need to empty the calendar and start from scratch.
But, why not use the calendar function that is built-in into your computer or one of many that can be found on-line. Then you can enter appointments, tasks, whatever. Keep track of history and view/report on whatever period (day, week, month, year) you are interested in.
Thank you so much. I liked the ergonomics of this calendar, and the fact that it can start automatically with the present day, so perpetual. I wanted to share this calendar with my team in a shared folder. Thank you for your advice, I will come back to something simpler. Thanks again for the time you have taken. Have a nice day