1000 days

[Crowbar_of_Irony_3]

The MS Excel method

1. In cell A1, type “19/6/2002”, assuming that your Excel’s default date format is DD/MM/YY. If not, just key in the date in a way which Excel will recongise.

2. Go to cell B1 type “=A1+1000”

3. Press [ENTER]. If a huge number appears, congrats, you are almost done. if a “!VALUE” appear insteads, check you have key in the date properly.

4. Right click on cell B1, select Format Cells, click on the Number tab, and chooses date.

Excel reveals the answers to be 15th March 2005

[Crowbar_of_Irony_3]

@LostCause

The MS Excel method

…snipped…

Excel reveals the answers to be 15th March 2005

Oops, someone else beats me to it! Argh.

[AHarris]

Those using the add 2 years method need to remember that 2004 was a leap year.

[Exapno_Mapcase]

In case anyone’s curious.

From David Ewing Duncan’s The Calendar:

[Joseph Justus Scaliger (1540 - 1609)] invented his own chronological calendar: the Julian day calendar, an ingenious if complex system that does not use individual years at all, but a cycle of 7,980 astronomic years that counts a day at a time, with no fractional days, no mean year and no leap years. He came up with his number by multiplying three chronologic cycles: an 18-year solar cycle, a 19-year lunar cycle, and the 15-year indiction period used by the Romans. All three cycles began together at the same moment at the start of his ‘Julian cycle,’ but would not converge again until the end.
…
Scaliger began his Julian cycle at noon on 1 January 4713 BC, which he based on calculations concerning Christ’s birthdate.

[picunurse]

@AHarris

Those using the add 2 years method need to remember that 2004 was a leap year.

:smack: