And here is one more planner.  Tired of staring at monthly calendars, I have designed
a long-term planner, a combination of a term calculator and a chart, to help work out
a plan based on To Do actions listed on the long term basis.  It is designed to show
a monthly time chart up to the year 2016.  This would help us put things into
 perspective to prioritize things to do over a given time frame.  Here is the file.
To start with, type in the starting year on the cell D7.
- June 9, 2001 -

And a weekly planner, designed to show the next 4 months, starting with the current
month (or type in any month in cell C1, eg. 2001/8), is posted.  This would
eliminate the hassle of looking up the first and last day of the month in a calendar.
Here is the file.
- June 13, 2001 -

The weekly planner is now combined with the monthly calendar
as well as 3-month calendar that shows the record marked on the year sheet,
which was posted on May 25, 2001.

On the weekly calendar, the schedule marked on the cell below
      the Monday date (eg. cell AY80) on the year sheet is shown above 
the corresponding Monday date.  

Personnel Terms & Headcount
Here is the file.
- November 21, 2001 -



On the monthly calendar, the schedule marked on the cell 2 lines below the date
(eg. cell AZ81) on the year sheet is shown on the corresponding date.

Here is the file.
- June 20, 2001 -

Here is Three Month Lookup Calendar 2002.  The 3-month and weekly 
calendars are modified to allow entry of more schedule data for each day and week
respectively.

On the weekly sheet, cell C1 carries this to show the current month
followed by the next 5 months.  

=DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(1))

Now, change this to the following:

=DATE(YEAR(TODAY()),MONTH(TODAY())+X,DAY(1))
Here in X comes any number of months before (+ changed to -) or after
the current month.

And you have cell C1 show any month to start the weekly calendar. 


Here is the file.
-September 8, 2001-



Excel Look-up Monthly Calendar  <I>

- June 20, 2000 -
Excel lookup function is used to show the anniversary and holiday listed on
the Annual Table, daily schedule of the week listed on the Weekly Table, 
and birthday listed on the Birthday Table,
all onto the corresponding columns of the monthly calendar (view).

- June 3, 2000 -
Staring at the calendar can be boring, unless it is one's only pastime.
I have figured out how Excel can be used to have my weekly schedule,
-- routine, that is, shown on the monthly calendar so as to avoid the hassle
of daily entry.  The look-up function is used to show the weekly events recorded
on "Weekly Table" onto the monthly sheet.  

Monthly Birthday Calendar for Centenarians lists the oldest man and woman in the world.

Age calculation for centenarians, what Excel does not support in simply
subtracting the birthdate before 1900/1/1  from today, is shown on
the spreadsheet with the names of 65 super centenarians (age over 109) in Japan,
announced by Ministry of Health, Labour and Welfare
on the occasion of Respect for the Aged holiday weekend.

- September 16, 2006 - 

Access Ken Matsuoka's original calendar with millennium countdown ,
which also has the new additional Weekly Calendar allowing insertion of photograph(s) 
(on cell B8 of the sheet Weekly), and you will figure out how you can use this 
to attract more access to your Web page, by showing the link with or without 
advertisement on the Excel work sheet.

Find out how the combination of the monthly calendar and the 3-Month Lookup
Calendar, posted on Mar. 3, 2001, works to make the records marked on the year
sheet stand out in the calendar of one (typically the current) month or 3 months.
Type a phrase in cell E81 of the year sheet for May 3 (next to "Kyoto" in cell D81),
and you will have the same shown on both the monthly and 3-month calendars.
Here is the file.  
- May 25, 2001 -

And here are my earliest works:

6-Month Dynamic Calendar; 12-Month Dynamic Calendar

- December 6, 2000 -

And more.   Here is World Clock UK.  The local times in Ohio,
Los Angeles and Tokyo are shown relative to the time in the UK (GMT).
- The latest version file has now the international dialing code sheet 
December 6, 2000 -




Ken's Home Radio
Ken's Tips on Utsunomiya

The Japan Times Top News of the Day and Archive