How many Days??

Question

How many days have there been since 20/08/86 to yesterday 18/03/07?

Basically i wanna know how old i am in days

Sorry Paul that can't be right, i'm 20 so i am at least 20*365 = 7300, have you missed a year?

Congrats to zzzzonked, you will get the points when i can issue them. I liked the excel idea but you missed one key point of adding a 1 to include both dates so the points go to the first correct answer. Just wanted to see how awake people were on Monday morning, i;m obviously dead to the world as i completely forgot about Excel. Thought i'd have to get out a calendar of something

Answer 1

congratulations you're 7 516 days old (including yesterday).

another 2 484 more days and you'll be celebrating your 10 000th day on this planet :)

by the way, you're also:
1073 weeks old, or
180 384 hours old, or
10 823 040 minutes old, or
649 382 400 seconds old

actually, depending on whether 2000 is a leap year, you could be 7515 or 7516 days old.

Answer 2

By my calculation which are probably wrong

7511

How I did this was use your 20 years equals 7300. Found the leap year which there were 5 of added them on. Then added the days from your birthday this year until yesterday which im hoping is 206. I did it on a calender.

Answer 3

7515. 7516 if you include the day you were born. That was up til and including yesterday 18/03/07.

Answer 4

In that period you had 5 leap years;
= 5 x 366 = 1830 days.
and 16 years at 365.25 days. = 5844 days.
In 1986 there were 133 days.
and in 2007 there were 77 days.

Total days = 210 + 5844 + 1830 = 7884 days.

Answer 5

Use Microsoft Excel.
Place both dates in two cells, e.g. A1 and A2.
In a third cell you substract the two, so in B1 you enter '=a2-a1'.

This works because Excel stores a date as the number of days since a certain date. That makes you can substract them to find the exact number of days between two dates.
Try it.

Answer 6

is 7516 days from the start date to the end date, end date included

Or 20 years, 6 months, 27 days including the end date

649,382,400 seconds
10,823,040 minutes
180,384 hours
1073 weeks (rounded down)

Answer 7

Number of days between two dates: DMY-dmy
[(Y * 365.25) + (M * 30.6) + (D)] - [(y * 365.25) + (m * 30.6) + (d)]
or
(2007*365.25) + (3*30.6) + 18 - (1986*360.25) - (8*30.6) - 20
= 7515.25 => 7515 days.
This includes the first date, excludes the second.
You can use that without excel!

Answer 8

7880 days

1986 - 365
1987 - 365
1988 - 366
1989 - 365
1990 - 365
1991 - 365
1992 - 366
1993 - 365
1994 - 365
1995 - 365
1996 - 366
1997 - 365
1998 - 365
1999 - 365
2000 - 366
2001 - 365
2002 - 365
2003 - 365
2004 - 366
2005 - 365
2006 - 365
Sum: 7670

August - 11
September- 30
October - 31
November - 30
December - 31
January - 31
February - 28
March - 18
Sum: 210

Total: 7880

Answer 9

7515 including yesterday.

Answer 10

7517 inclusive of the dates mentioned.