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.

• 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...
• What is the #1 mistake women make when dating? Pay attention single ladies because you are making a drastic mistake when Dating! Listen up girlfriend and friends and family...
• Seck 1882 Hey man, hope all is going well with your visitors this week (editors note: SGI USA visitors to set up...
• DSLR Panasonic Lumix DMC-G2 Review [/caption] Panasonic's G1 was not only the first product of the Micro Four Thirds standard, it was also the world's...
• Treat Everyone At Work With Respect It’s been a while since I’ve written about career, I think we fired off both barrels during Career Week 2009...