Print PDF
Favorite
Email
Step 3Build a List of New Year's Days
In cell A2, enter the date 1/1/1901. Excel has a bug that incorrectly assumes that 1900 was a leap year, so don't start before 1901. The rule for leap years is simple: The year has to be evenly divisible by 4, unless the year ends in 00 in which case the year also has to be evenly divisible by 400. Thus, 1900 was not a leap year, but 2000 was.
In cell A3, enter the date 1/1/1902. Hold down your left mouse, and select cells A2 and A3. You'll notice that in the lower-right corner of the selection there's a small black box; holding down your left mouse button, select the small black box and drag down (when your mouse is hovering over the correct place, it will turn into a 'plus' sign). As you drag down, you'll notice that a date will be displayed. Drag down until you get to 1/1/2036 and release the left mouse button. That's when I'll be able to retire, given the current market!
In cell A3, enter the date 1/1/1902. Hold down your left mouse, and select cells A2 and A3. You'll notice that in the lower-right corner of the selection there's a small black box; holding down your left mouse button, select the small black box and drag down (when your mouse is hovering over the correct place, it will turn into a 'plus' sign). As you drag down, you'll notice that a date will be displayed. Drag down until you get to 1/1/2036 and release the left mouse button. That's when I'll be able to retire, given the current market!
| « Previous Step | Download PDFView All Steps | Next Step » |
 |
Add Comment
|
