# 1000 days

**URL:** <https://boards.straightdope.com/t/1000-days/305727>\
**Category:** Factual Questions\
**Created:** [May 27, 2005, 5:19am UTC](https://boards.straightdope.com/t/1000-days/305727 "2005-05-27T05:19:06Z")\
**Posts on this page:** 5\
**Page:** 2

<div class="post-metadata">

**Author:** ![Crowbar\_of\_Irony\_3](https://avatars.discourse-cdn.com/v4/letter/c/f08c70/32.png) [@Crowbar\_of\_Irony\_3](https://boards.straightdope.com/u/Crowbar_of_Irony_3)\
**Post date:** [May 27, 2005, 3:56pm UTC](https://boards.straightdope.com/t/1000-days/305727/21 "2005-05-27T15:56:05Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Crowbar\_of\_Irony\_3](https://avatars.discourse-cdn.com/v4/letter/c/f08c70/32.png) [@Crowbar\_of\_Irony\_3](https://boards.straightdope.com/u/Crowbar_of_Irony_3)\
**Post date:** [May 27, 2005, 3:57pm UTC](https://boards.straightdope.com/t/1000-days/305727/22 "2005-05-27T15:57:21Z")

</div>

> [@LostCause](#):
>
> The MS Excel method
> 
> …snipped…
> 
> Excel reveals the answers to be 15th March 2005

Oops, someone else beats me to it! Argh.

---

<div class="post-metadata">

**Author:** ![AHarris](https://avatars.discourse-cdn.com/v4/letter/a/bcef8e/32.png) [@AHarris](https://boards.straightdope.com/u/AHarris)\
**Post date:** [May 27, 2005, 4:00pm UTC](https://boards.straightdope.com/t/1000-days/305727/23 "2005-05-27T16:00:34Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Exapno\_Mapcase](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/exapno_mapcase/32/1051_2.png) [@Exapno\_Mapcase](https://boards.straightdope.com/u/Exapno_Mapcase)\
**Post date:** [May 27, 2005, 4:02pm UTC](https://boards.straightdope.com/t/1000-days/305727/24 "2005-05-27T16:02:41Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![picunurse](https://avatars.discourse-cdn.com/v4/letter/p/7bcc69/32.png) [@picunurse](https://boards.straightdope.com/u/picunurse)\
**Post date:** [May 27, 2005, 9:32pm UTC](https://boards.straightdope.com/t/1000-days/305727/25 "2005-05-27T21:32:22Z")

</div>

> [@AHarris](#):
>
> Those using the add 2 years method need to remember that 2004 was a leap year.

:smack:

[Previous page](https://boards.straightdope.com/t/1000-days/305727.md?page=1)