The world, of course, didn’t begin on January 1, 1900. People who use Excel to work with historical information often need to work with dates before January 1, 1900. Unfortunately, the only way to work with pre-1900 dates is to enter the date into a cell as text. For example, you can enter July 4, 1776 into a cell,
and Excel won’t complain.

You can’t, however, perform any manipulation on dates entered as text. For example, you can’t change its numeric formatting, you can’t determine which day of the week this date occurred on, and you can’t calculate the date that occurs seven days later.

My Power Utility Pak add-in includes eight new worksheet functions that enable you to work with any date in the years 0100 through 9999. Figure 16-2 shows a worksheet that uses these extended date functions in columns E though H to perform calculations that involve pre-1900 dates. You can download a trial version of Power Utility Pak from my Web site (http://j-walk.com/ss).

FIGURE 16-2
The author’s Extended Date Functions add-in enables you to work with pre-1900 dates.

• Old Post Promoter "You down with OPP, yeah you know me!" The OPP, or Old Post Promoter, is a plugin designed for Wordpress...
• You must believe in abundance for attraction to work! There are many people today who wish to live "in attraction". They understand that what they focus on, either good...
• Weekend Links - Napa Treat Edition Yesterday, I had the unique opportunity to get a couple of private tastings and tours in Napa. It was due...
• A Simple Mortgage Amortization Table Kevin over at the No Debt Plan blog recently advised his readers to avoid mortgage accelerator programs like the plague. ...
• Sip Phone And The Cost Savings Benefits What is an SIP phone? This is a piece of hardware that is used with SIP and VOIP offered by...