SOLVED

date display

%3CLINGO-SUB%20id%3D%22lingo-sub-1399443%22%20slang%3D%22fr-FR%22%3Edate%20display%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1399443%22%20slang%3D%22fr-FR%22%3E%3CP%3EI%20downloaded%20has%20miscrosoft%20schedule%20template.%20But%20there%20is%20a%20problem.%20Why%20in%20cell%20C3%20does%20he%20not%20put%20the%20date%20in%20cell%20G2%3F%20%3CBR%20%2F%3E%20If%20someone%20could%20correct%20me%20this%20error%2C%20thank%20you%20very%20much%20for%20your%20help%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1399443%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1399557%22%20slang%3D%22en-US%22%3ERe%3A%20date%20display%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1399557%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F669877%22%20target%3D%22_blank%22%3E%40Trankil%3C%2FA%3E%26nbsp%3BC3%20has%20the%20function%20WEEKDAY%20(JOURSEM%20in%20French).%20This%20returns%20de%20day%20number%20in%20the%20week%20of%20the%20given%20date%20(i.e.%201%20to%207).%20Row%20three%20is%20formatted%20as%20%22long%20date%22%20and%20then%20Excel%20takes%20%3CSTRONG%3Eday%3C%2FSTRONG%3E%20number%202%20a%20%3CSTRONG%3Edate%3C%2FSTRONG%3E%20number%20two%2C%20being%20January%202%2C%201900.%3C%2FP%3E%3CP%3EI'm%20not%20familiar%20with%20this%20template%2C%20but%20if%20you%20want%20C3%20to%20display%20the%20date%20in%20G2%2C%20just%20over-write%20the%20formula%20with%20%3CSTRONG%3E%3DG2%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1399575%22%20slang%3D%22en-US%22%3ERe%3A%20date%20display%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1399575%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F669877%22%20target%3D%22_blank%22%3E%40Trankil%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20C3%20is%20weekday%2C%20not%20date.%20Please%20format%20as%20%3CSTRONG%3Edddd%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1399657%22%20slang%3D%22fr-FR%22%3ERe%3A%20date%20display%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1399657%22%20slang%3D%22fr-FR%22%3E%3CP%3Ethank%20you.%20But%20I%20want%20a%20long%20date.%20Is%20it%20possible%2C%20keeping%20a%20week%20that%20always%20starts%20with%20the%20present%20day%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1399663%22%20slang%3D%22fr-FR%22%3ERe%3A%20date%20display%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1399663%22%20slang%3D%22fr-FR%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20You.%20I%20don't%20know%20too%20much%20about%20Excel%2C%20that's%20why%20I%20downloaded%20a%20microsoft%20model.%20But%20I%20would%20like%20to%20keep%20this%20schedule%20but%20with%20a%20long%20date%20on%20line%203.%20%3CBR%20%2F%3E%20Let%20the%20first%20day%20be%20automatically%20the%20present%20day.%20And%20that%20there%20are%2031%20days%20in%20a%20row.%20%3CBR%20%2F%3E%20It's%20possible%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1399739%22%20slang%3D%22en-US%22%3ERe%3A%20date%20display%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1399739%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F669877%22%20target%3D%22_blank%22%3E%40Trankil%3C%2FA%3E%26nbsp%3BJust%20enter%20%3DG2%20in%20C3.%20That%20should%20do%20it.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1401101%22%20slang%3D%22en-US%22%3ERe%3A%20date%20display%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1401101%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F669877%22%20target%3D%22_blank%22%3E%40Trankil%3C%2FA%3E%26nbsp%3BSorry%2C%20I%20didn't%20read%20your%20entire%20question%20and%20my%20previous%20response%20was%20a%20bit%20too%20quick.%20I%20attach%20your%20file%20with%20some%20revisions.%20But%2C%20I%20must%20say%20that%20this%20template%20doesn't%20seem%20to%20be%20very%20useful%20and%20its%20only%20purpose%20seems%20to%20be%20to%20teach%20about%20the%20WEEKDAY%20function%2C%20calculate%20with%20time%20intervals%20and%20how%20to%20use%20named%20ranges%20and%20named%20formulae.%20It's%20full%20of%20these%20last%20two%20features.%20I%20expanded%20the%20calendar%20table%20to%20contain%2031%20days%2C%20but%20perhaps%20it%20broke%20some%20of%20the%20features%20in%20the%20template.%20Can't%20be%20sure%20until%20you%20test%20it.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1401647%22%20slang%3D%22fr-FR%22%3ERe%3A%20date%20display%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1401647%22%20slang%3D%22fr-FR%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3BGreat.%20Thank%20you%20very%20much%2C%20it's%20really%20nice%20to%20have%20taken%20the%20time%20to%20help%20me.%20I%20don't%20know%20Excel%20very%20well%2C%20but%20I%20need%20a%20practical%20schedule%20to%20manage%20rooms%20for%20children%2C%20to%20manage%20protective%20measures%20against%20the%20codiv%20virus.%20I%20will%20try%20it%20out%20and%20tell%20you%20if%20everything%20is%20working%20well.%20Many%20thanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1405965%22%20slang%3D%22fr-FR%22%3ERe%3A%20date%20display%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1405965%22%20slang%3D%22fr-FR%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGood%20morning.%20The%20calendar%20starts%20well%20on%20the%20present%20day.%20But%2C%20the%20appointments%20I%20entered%20are%20each%20displayed%20the%20next%20day.%20Example%3A%20yesterday%2C%20I%20put%20%22Julie%20Workshop%22%20on%20Friday%20May%2020%2C%20at%2011%3A00.%20Today%20it%20appears%20Thursday%20May%2021%2C%2011am.%20Same%20for%20all%20the%20other%20meetings.%20Do%20you%20think%20you%20can%20attach%20the%20appointments%20to%20their%20date%20and%20not%20to%20their%20cell%3F%20Thank%20you%20very%20much%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1406334%22%20slang%3D%22fr-FR%22%3ERe%3A%20date%20display%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1406334%22%20slang%3D%22fr-FR%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethank%20you%20for%20your%20reply.%20here%20is%20the%20link%20to%20the%20english%20version%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftemplates.office.com%2Fen-us%2Fdaily-appointment-calendar-week-view-tm00000044%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Ftemplates.office.com%2Fen-us%2Fdaily-appointment-calendar-week-view-tm00000044%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1407536%22%20slang%3D%22en-US%22%3ERe%3A%20date%20display%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1407536%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F669877%22%20target%3D%22_blank%22%3E%40Trankil%3C%2FA%3E%26nbsp%3BThanks%20for%20the%20link.%20Have%20looked%20at%20the%20template%20and%20now%20dare%20to%20say%20that%20I%20consider%20it%20totally%20useless.%20It's%20no%20better%2C%20and%20probably%20worse%2C%20than%20just%20writing%20your%20appointments%20in%20a%20paper%20calendar.%20All%20that%20this%20template%20allows%20you%20to%20do%20is%20set%20the%20start%20of%20the%20day%20(C2)%2C%20the%20time%20interval%20between%20calendar%20entries%20(E2)%20and%20the%20data%20for%20the%20%3CSTRONG%3Efirst%3C%2FSTRONG%3E%20day%20in%20the%20week%20(G2).%20Now%2C%20the%20real%20dumb%20thing%20with%20this%20template%20is%20that%20G2%20contains%20the%20formula%20%3CSTRONG%3E%3DTODAY()%3C%2FSTRONG%3E.%20It%20suggests%20that%20the%20schedule%20is%20dynamic%20in%20some%20way%2C%20automatically%20updating%20something%20every%20day.%20Unfortunately%2C%20it's%20not.%20As%20you%20noted%20yourself%2C%20the%20calendar%20entries%20are%20stuck%20in%20a%20cell%20and%20will%20not%20move%20with%20the%20day%20of%20the%20week%20or%20time%20of%20the%20time%20when%20the%20settings%20in%20the%20above-mentioned%20cells%20change.%20So%2C%20If%20you%20insist%20on%20using%20the%20template%20that%20I%20amended%20for%20you%20earlier%2C%20you%20need%20to%20set%20the%20three%20cells%20mentioned%20above%20first%20and%20get%20rid%20of%20the%20TODAY%20formula.%20Just%20type%20the%20date%20you%20want%20the%20calendar%20to%20start%20with.%20And%20then%20start%20entering%20your%20appointments%2Ftasks.%20For%20every%20new%20period%2C%20you%20need%20to%20empty%20the%20calendar%20and%20start%20from%20scratch.%3C%2FP%3E%3CP%3EBut%2C%20why%20not%20use%20the%20calendar%20function%20that%20is%20built-in%20into%20your%20computer%20or%20one%20of%20many%20that%20can%20be%20found%20on-line.%20Then%20you%20can%20enter%20appointments%2C%20tasks%2C%20whatever.%20Keep%20track%20of%20history%20and%20view%2Freport%20on%20whatever%20period%20(day%2C%20week%2C%20month%2C%20year)%20you%20are%20interested%20in.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1408142%22%20slang%3D%22fr-FR%22%3ERe%3A%20date%20display%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1408142%22%20slang%3D%22fr-FR%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20so%20much.%20I%20liked%20the%20ergonomics%20of%20this%20calendar%2C%20and%20the%20fact%20that%20it%20can%20start%20automatically%20with%20the%20present%20day%2C%20so%20perpetual.%20I%20wanted%20to%20share%20this%20calendar%20with%20my%20team%20in%20a%20shared%20folder.%20Thank%20you%20for%20your%20advice%2C%20I%20will%20come%20back%20to%20something%20simpler.%20Thanks%20again%20for%20the%20time%20you%20have%20taken.%20Have%20a%20nice%20day%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1406045%22%20slang%3D%22en-US%22%3ERe%3A%20date%20display%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1406045%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F669877%22%20target%3D%22_blank%22%3E%40Trankil%3C%2FA%3E%26nbsp%3BThat%20I%20haven't%20looked%20at%20as%20I%20didn't%20go%20in%20depth%20to%20understand%20the%20template.%20Where%20did%20you%20download%20the%20template%3F%20Perhaps%20there%20is%20on%20in%20English%20version%20of%20it%20as%20well.%20Then%2C%20I%20can%20better%20understand%20how%20it%20is%20supposed%20to%20work.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

I downloaded a miscrosoft schedule template. But there is a problem. Why in cell C3 does he not put the date in cell G2?
If someone could correct me this error, thank you very much for your help

12 Replies
Highlighted

@Trankil C3 has the function WEEKDAY (JOURSEM in French). This returns de day number in the week of the given date (i.e. 1 to 7). Row three is formatted as "long date" and then Excel takes day number 2 a date number two, being January 2, 1900.

I'm not familiar with this template, but if you want C3 to display the date in G2, just over-write the formula with =G2

Highlighted

@Trankil 

In C3 is weekday, not date. Please format as dddd

Highlighted

thank you. But I want a long date. Is it possible, keeping a week that always starts with the present day?

 

Highlighted

@Riny_van_Eekelen 

Thank you. I don't know too much about Excel, that's why I downloaded a microsoft model. But I would like to keep this schedule but with a long date on line 3.
Let the first day be automatically the present day. And that there are 31 days in a row.
It's possible?

Highlighted

@Trankil Just enter =G2 in C3. That should do it.

Highlighted

@Trankil Sorry, I didn't read your entire question and my previous response was a bit too quick. I attach your file with some revisions. But, I must say that this template doesn't seem to be very useful and its only purpose seems to be to teach about the WEEKDAY function, calculate with time intervals and how to use named ranges and named formulae. It's full of these last two features. I expanded the calendar table to contain 31 days, but perhaps it broke some of the features in the template. Can't be sure until you test it.

Highlighted

@Riny_van_Eekelen Great. Thank you very much, it's really nice to have taken the time to help me. I don't know Excel very well, but I need a practical schedule to manage rooms for children, to manage protective measures against the codiv virus. I will try it out and tell you if everything is working well. Many thanks

Highlighted

@Riny_van_Eekelen 

Hello. The calendar starts well on the present day. But, the appointments I entered are each displayed the next day. Example: yesterday, I put "Atelier Julie" on Friday May 20, at 11:00. Today it appears Thursday May 21, 11H. Same for all the other meetings. Do you think you can attach the appointments to their date and not to their cell? Thank you very much

Highlighted

@Trankil That I haven't looked at as I didn't go in depth to understand the template. Where did you download the template? Perhaps there is an English version of it as well. Then, I can better understand how it is supposed to work.

Highlighted

@Riny_van_Eekelen 

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

Highlighted
Best Response confirmed by Trankil (Occasional Contributor)
Solution

@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.

Highlighted

@Riny_van_Eekelen 

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