More to them than meets the eye.Last week, I shared with you some thoughts, reflections, and results from my 21 Day Fix Journey. I find this and some of the other templates deceptively simple. They're all using a "Day Only" custom Data Format.Īnd there's Conditional Highlighting to "fade out" the cells that are not in that month:Īn interesting showcase for the power of Numbers. The two little calendars are constructed in the same way. Then the other cells in the main calendar flow from that anchor value, cells to the right adding a day via =A2+DURATION(0,1), and cells below adding a week via =A2+DURATION(1) Then in the main calendar the "anchor" value in A2 is derived this way:Īll that's doing is taking the first-day of the month date and adding (1-the day of the week of the first day of the month). That's it! (Rows 8 through 14 are for the previous month and next month calendars and make it all look more complicated than it is). It figures out what day of the week that is (which depends on q's factor) and also gets the last day of the month. It simply constructs the first day of the month from the Popup choices for month and year and using a day of 1. the formulas are all simple, there's no modular arithmetic with MOD(), all quite simple really! Well, realizing that my "list of things I don't quite understand" is already long enough, and armed with the discovery of "quinn's factor" in A3 and observations of the behavior I had observed when simply adding a column, I decided to have another look, and discovered. Also easy to manually count days or weeks until an event.Ĭonditional Highlighting (change of month name, 1st of a month) does help with visual cues. It's only a once-a-year job, and it allows me to see the year at a glance. I now use a very simple year planner and manually update it each year.Ĭonsult a "real" calendar such as the Calendar app on the Mac or a printed calendar and enter dates. It would not convert to Numbers, and I forgot how I did it, so I gave up. It took me several days and many convoluted formulas. Years ago, I did create an Excel "Year Planner" that was fully automatic (just enter the year and it calculated 1st January, it entered 1 in the correct cell, calculated following dates, the start of the next month and allowed for Leap Years). Then Saturday and Sunday are nice and snug on the right (weekend events often run for two days). Like vesterberg, I like to start on a Monday. Different days in each month, leap years, start the week on a Sunday or a Monday. I have always found constructing calendars a challenge. I realise this is not really helping, but it might get you (or another user) started. The table names will help to show how the formulas work.Īlso, have a look at Format Panel > Cell > Conditional Highlighting to see why some dates in the main calendar (last month, next month) are grey. They are in a table.Ĭlick on the previous and the following months, and the current calendar. To see how it was constructed, click on the month (September in my version) or year (2014 in my example). Perhaps other Numbers users will stop by with ideas. I do not know how to answer your question, but here are some hints that may help you get started. I take my hat off to whoever created that Calendar Template for Numbers 3. Neither System Preferences nor Calendar app will change the Numbers Calendar Template. Hi vesterberg, I've already setup Monday to start the week in the general settings and in the Calendar app settings but that doesn't do much in Numbers.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |