Excel handles dates by using a serial number system. The earliest date that Excel understands is January 1, 1900. This date has a serial number of 1. January 2, 1900, has a serial number of 2, and so on. This system makes it easy to deal with dates in formulas. For example, you can enter a formula to calculate the number of days between two dates.

Most of the time, you don’t have to be concerned with Excel’s serial number date system. You can simply enter a date in a familiar date format and Excel takes care of the details behind the scene.

For example, if you need to enter June 1, 2007, you can simply enter the date by typing June 1, 2007 (or use any of several different date formats). Excel interprets your entry and stores the value 39234, which is the date serial number for that date.

• Barclays Premier League Predictions and Analysis March 20th 2010 Part 1 [/caption] Good morning to all UK football bettors, gamblers, tipsters and everyone else that has decided to visit me. A...
• Prosper Estimated Return Guidance Pessimistic Example -- aka PML #5 -- Pay off high interest home improvement cards In my Friday post, I encouraged everyone to think for themselves when it comes to estimated return guidance. It is...
• My Prosper Internal Rate of Return Update (End of Feb 07) = 12.86% for an Increase of 0.65% This is a RateLadder only IRR update.  (An IRR lender "game" update is in the works.) Here is my permanent...
• Lottery Numbers Higher Even In Down Economy Seems strange to report that results from lottery sales were higher in 2008 than in year's past. You would think...
• Prime Borrowing on Prosper Hits Record Levels -- Febuary Marketplace Survey SAN FRANCISCO--(BUSINESS WIRE)--March 11, 2008--Spurred by the credit crunch, attractive rates, and lender demand for conservative assets, Prosper (www.prosper.com), America's...