need to know number of days between September 21, 1991 and Decemebr 15, 2006?

Answer 1

There are 15 years between 1991 and 2006.

So you need 15 x 365 = 5,475 days
Then you have leap years in 1992, 1996, 2000, 2004 so add another 4 days.
That gets you to 9/21/2006 and 5,479 days

From 9/21 to 10/21 is 30 days --> 5,509 days
From 10/21 to 11/21 is 31 days ---> 5,540 days
From 11/21 to 12/21 is 30 days ---> 5,570 days
But now you need to go back 6 days. ---> 5,564 days

(A quick check in Excel confirms the result).

A person born on September 21, 1991 would be 5,564 days old today.

Note, the correct way to figure the difference between dates is to subtract. You can't exclude both end dates, and you can't include both end dates, but you must count them once, not zero or twice.

For example, the difference between today and tomorrow is 1 day, not zero or 2 days.

Anyway, the correct answer is 5,564 days.

Answer 2

'This figures out day differences based on the number of days since Christ was born in computer basic. It's all about finding common terms. It is kind of neat to know how many days it has been since the first Christmas. I wrote this software about 15 yrs ago but it still works fine.... logic is logic
'set up how many days per month

MDAY%(1) = 31: MDAY%(2) = 28: MDAY%(3) = 31
MDAY%(4) = 30: MDAY%(5) = 31: MDAY%(6) = 30
MDAY%(7) = 31: MDAY%(8) = 31: MDAY%(9) = 30
MDAY%(10) = 31: MDAY%(11) = 30: MDAY%(12) = 31

YEAR_NOW = Val(Mid$(Date$, 7, 4))
MONTH_NOW = Val(Mid$(Date$, 1, 2))
day_now = Val(Mid$(Date$, 4, 2))
X% = 0
For X1% = 1 To MONTH_NOW - 1
X% = X% + MDAY%(X1%)
Next X1%
day_now = day_now + X% + (YEAR_NOW * 365) + (YEAR_NOW \ 4)

' this next step corrects for being a leap year this year but not yet February 29th for the day it is today.

If YEAR_NOW Mod 4 = 0 And Val(Mid$(Date$, 1, 2) +
Mid$(Date$, 4, 2)) < 229 Then day_now = day_now - 1
day_original = 0921 Mod 100
'modulo arithmatic gives you the remainder. In this case it will end up being 9 with a remainder of 21 day_original = 21
MONTH_ORIGINAL = (0921 - day_original) / 100

X% = 0
For X1% = 1 To MONTH_ORIGINAL - 1
X% = X% + MDAY%(X1%)
Next X1%
YR_ORIGINAL = 1991

' The backwards division sign is integer math. It drops the remainder
day_original = day_original + X% + (YR_ORIGINAL * 365) + (YR_ORIGINAL \ 4)

' this next step corrects for being a leap year this year but not yet February 29th for the comparison year
If YR_ORIGINAL Mod 4 = 0 And 0921 <= 229 Then day_original = day_original - 1

DAY_LAPSE = day_now - day_original

'if you plug in your dates 9/21/1991 and 12/15.2006 there is a difference of 5,564 days accounting for leap years


5,564 = (733,040 [dec 15,2006)]) minus (727,476 [Sep 21,1991)

Answer 3

According to Excel, it's 5563 (that's days in-between. If you want to include those dates, add 2).

P.S. the guy that states that he used Excel and got 5564 (z0plax)simply subtracted the 1991 date from the 2006 date. That means he included the 2006 date - which is why he got one more than me.

The next guy included both dates (ethan), that's why he got two more than me.

Answer 4

5565 days including the leap years & including 21-Sep-91 & 15-Dec-06.

Answer 5

5563 days including the leap years. +2 if you include the days

Answer 6

5564

Answer 7

5,564