Today is: Wednesday, November 30, 2011
Today is the: 334 th Day of the year 91.51%
There are: 31 Days Left in the year 8.49%
Total Days: 365 This Year
There are: 25 Shopping days till Christmas
So Far:
238 Working Days in the year: 91.54%
22 Working Days Left in the year 8.46%
Total Working Days: 260 For this year
Options:
Display Current Year: Y 2013
Highlight today's date: N Show Holidays: N
Make your calendar selection
options on this page and then click N
on the tab at the bottom to display Bank Holiday N
the calendar of your choice. The N
yearly calendars will display 1, 2 or N
3 years worth of information, the N
monthly calendar will display a N
single month and allow you to type N
information. N
N
See the FAQ for more information: N
FAQ
30, 2011
Percent Complete
Percent Remaining
Percent Complete
Percent Remaining
2011
July August September
S M T W T F S S M T W T F S S M T W T F S
1 2 1 2 3 4 5 6 1 2 3
3 4 5 6 7 8 9 7 8 9 10 11 12 13 4 5 6 7 8 9 10
10 11 12 13 14 15 16 14 15 16 17 18 19 20 11 12 13 14 15 16 17
17 18 19 20 21 22 23 21 22 23 24 25 26 27 18 19 20 21 22 23 24
24 25 26 27 28 29 30 28 29 30 31 25 26 27 28 29 30
31
October November December
S M T W T F S S M T W T F S S M T W T F S
1 1 2 3 4 5 1 2 3
2 3 4 5 6 7 8 6 7 8 9 10 11 12 4 5 6 7 8 9 10
9 10 11 12 13 14 15 13 14 15 16 17 18 19 11 12 13 14 15 16 17
16 17 18 19 20 21 22 20 21 22 23 24 25 26 18 19 20 21 22 23 24
23 24 25 26 27 28 29 27 28 29 30 25 26 27 28 29 30 31
30 31
2012
January February March
S M T W T F S S M T W T F S S M T W T F S
1 2 3 4 5 6 7 1 2 3 4 1 2 3
8 9 10 11 12 13 14 5 6 7 8 9 10 11 4 5 6 7 8 9 10
15 16 17 18 19 20 21 12 13 14 15 16 17 18 11 12 13 14 15 16 17
22 23 24 25 26 27 28 19 20 21 22 23 24 25 18 19 20 21 22 23 24
29 30 31 26 27 28 29 25 26 27 28 29 30 31
April May June
S M T W T F S S M T W T F S S M T W T F S
1 2 3 4 5 6 7 1 2 3 4 5 1 2
8 9 10 11 12 13 14 6 7 8 9 10 11 12 3 4 5 6 7 8 9
15 16 17 18 19 20 21 13 14 15 16 17 18 19 10 11 12 13 14 15 16
22 23 24 25 26 27 28 20 21 22 23 24 25 26 17 18 19 20 21 22 23
29 30 27 28 29 30 31 24 25 26 27 28 29 30
School re-opening days are shown in Blue
Half-days are shown in Green
Holidays are shown in Red
December 8th School Closed
Confirmation March 29th
Holy Communion May 5th
Click to
return to
"Start
Here"
Q
A
Q
A
Q
A
Q
A
Q
A
Q
A
Q
A
Q
A
Q
A
Q
A
Q
A
Q
A
Q
A
How do I change the calendar to another date?
Click on the box that says "Display Current Year" and change it to "N" An option will be displayed to allow you
to put in any year from 1900-9999.
Why does it always ask me to save my changes, even when I have not made any?
To determine the current date the entire spreadsheet is recalculated when you open it. This causes the
spreadsheet to think that you have made changes.
Our company does not observe all federal holidays, how do I change that?
Each of the ten federal holidays has a Y/N option to the right. By changing the holiday that you want to
remove to "N" it will not be displayed on any of the other tabs. If you wish to remove all holidays, change the
"Show Holidays" option to "N".
Do you plan to add holidays for other countries?
No. You are welcome to edit the file and make those changes yourself if you wish.
Can this calendar display holidays such as Mothers Day and Fathers Day?
No. There are numerous "non" holidays, such as Valentines, Easter, St. Patrick's day. To be fair and
consistent, only U.S. Federal Holiday's are shown. You are welcome to edit the file and make those changes
yourself if you wish.
Martin Luther King was not born until 1929, but your program displays his birthday for the years before that.
Why?
There have been numerous changes to the federal holiday schedule. During the 20th century the dates we
observe for most holidays (including Thanksgiving) has changed. This program was not trying to be
historically accurate, but reflect the current rules regarding holidays. Who knows what (or any) holidays we
will be celebrating in 9999?
You said that the calendar displays the years 1900 - 9999, but if I put the year 1900 and then look at the "3
YR" tab I can see 1899! What happened?
In order to allow the "3 Yr" tab to work for 1900 the proper calendar for 1899 was added. It is only possible to
see it on this tab and it does not allow you to display previous years. Conversely, if you put in the year 9999
you will see the years, 9998 and 9999 displayed, however the year 10,000 has no dates and will just show
###
If I display the year 1901 and then look at the "3Yr" tab the holidays for 1900 are not right. What happened?
This is related to a known error (see Why does the calendar start with 1900?). The calendar itself is correct,
however the challenge of correcting the holidays for just that portion of the calendar were deemed to be
unnecessary. If you want to see the holidays for 1900, use 1900 as your date and not 1901.
Can you explain how you get the calendars and holidays?
There are several hidden tabs (right click on a tab to unhide). Each of these tabs has an information area
briefly outlining its purpose and use. If you look at these tabs you will start to see how this was created. It
would take to much time here to go into detail on how this was achieved, but a basic concept was that if we
could produce a formula that told us when a holiday would occur for a given year then we would use the
"Conditional Format" options to display this. Each sheet has hidden sections that determine when those
dates are. You are welcome to unhide the various tabs and sections of the worksheets to see how it was
done. Make a copy though! There are tens of thousands of formulas and it took hundreds of hours to create.
I noticed that the sheets are password protected, what is the password?
There is no password. The sheets have been protected, just to keep me (and you) from accidently deleting
something. Just click on unprotect if you wish to make modifications.
Why does the calendar start in 1900 and not the year 1?
Excel uses a numbering system for dates that causes January 1st, 1900 do be day one, January 2nd, 1900 to
be day two and so on. In fact today is: 11/30/2011 which is the 40877 day since January 1st 1900. Since this
is the normal for Excel, dates prior to this are more difficult to calculate in a spreadsheet. If you need a
calendar for dates prior to 1900, there are many online.
February 1900 is missing a leap year in your calendar! When I check it with Excel it shows 2/29/1900. What
happened?
The fact of the matter is that there was NO February 29th 1900. Other perpetual calendars that show this
date are actually in error. A great deal of recalculation was made to show the proper calendar and avoid this
problem.
The reason why 1900 had no leap year is a little complicated. The Gregorian calendar that we use today has
a leap year every 4th year (just as the Julian calendar before it did). The earth, however does not travel
around the sun in exactly 365.25 days per year. It is actually off by a little bit. To correct for that Pope
Gregory adjusted the calendar in 1583 so that leap year does not occur in years that end with 00 (i.e. 1700,
1800, 1900, etc.) UNLESS they are divisible by 400. Therefore the year 1900 was NOT a leap year, but the
year 2000 was. In effect during any 400 year period instead of 100 leap years, there are now 97.
This has actually caused a number of problems throughout history (prior to Excel). The United States was at
the time a British colony and being Protestant refused to adopt the new calendar. This continued until 1752
when the change was finally made. That year to correct for the differences in the calendar the dates between
September 2nd 1752 and September 14th were removed. In effect the year was short by 11 days.
So, what happened with Excel?
To be fair, the people at Microsoft realized the problem. Previous spreadsheet programs had included this
error and to ensure that the dates were compatible with other programs they chose to allow the error to
continue. If you really are concerned about it, there is a mode that will allow you to calculate dates starting in
1904 rather than 1900. This one is 100% accurate.
11/30/2011 40,877