Not for lack of trying but I must ask the following…
starting at 6/19/2002 - what date will 1000 says later fall on?
days later :smack:
April 13 2005
:dubious: Why?
Wait, Its April 16th 2005 I think…
No, it’s March 15, 2005, idnit?
Using a julian date converter, yes, its March 15[sup]th[/sup], 2005 (put in the date, get the julian, add 1000 to that, get the date…)
Ok, I did it again and got March16th
RM Mentock, how did you do it? My methods are strange. I subtracted 365 from 1000 until it was less than 1 year I had 270 days left. I then subtracted the remaining 11 days in June. Then I subtracted 31, 31, 30, 31, 30, 31, 31, 28. the remainder was 16. so March 16th
Yes. For these kind of questions, it’s easiest to use a Julian Date converter. Jun 19, 2002 is Julian Date 2452444.5. Add 1000 days to get Julian Date 2453444.5. Finally convert that back to March 15, 2005.
There are many Julian Date converter sites on the web. I used the one at the U.S. Naval Observatory here.
That’s certainly what I got using the date function on my HP calculator.
Or what Hail Ants said… I need to type faster or spend less time wordsmithing.
I used your calculator, but instead of adding 1000, I advanced the date 2 years then added 270 the number of days left, and the result was March 16 2005 But when I just added 1000, it comes out 3/15/2005 ??? 
Thanks all. said number of days plus then till now will equate the number of days that I have been … well, since my wife passed.
That’s very sad. I’m sorry for your loss.
Advancing the date two years from 19 June 2002 would be 731 days, not 730 days, because 2004 was a leap year and included 29 February. So you only need to add a further 269 days, which takes you to 15 March 2005.
Excel.
19/06/2002
1000
15/03/2005 (FORUMLA =A1+A2)
As Bearflagsaid, the time and date site is the place to go.
Specifically this page: http://www.timeanddate.com/date/dateadd.html
will calculate just what you want and I also got March 15, 2005.
Thank you for your kind words Derleth, and all else for a solid footing on my little work in progress.
I did it in my head. I am a very good calculator, very good.
Another trick: if you know the day of the week of D-Day (USAn, June 6, invasion of Europe during WWII), then it’s the same as 4/4, 6/6, 8/8, 10/10, and 12/12 of that year. Also, 9/5 and 5/9, as well as 7/11 and 11/7. The last day of February, too–so it’ll be the last day of January (the 31st of course) as well, except in leap year. And March 7/14/21/28–so the Ides is the day after.
Sorry Bob, but glad to help.
Using the SQL statement:
SELECT Dateadd(dd, 1000, '06/19/2002')
returns March 15th, 2005.