*I have resolved determining day of week for dates prior to 1900. So
simple, I feel ridiculous. XDATE provides the answer!!! Here it is:
=XDATE(1702,6,20,"YYYY-MMM-DD ddd")
(Color emphasis my own.)
**
The "ddd" gives the day of the week for that date!!!!!!!
**Thank you.
**Robert*
*Genealogy without documentation is mythology! Always SOURCE your work.*
On Sun, Jan 15, 2012 at 7:25 PM, <david.smart@ubs.com> wrote:
> **
>
>
> A bit further Googling leads me to believe that 400 is not a same-day
> year adjuster.
>
> The basic one seems to be 28 years. This presumably compensates for
> normal leap years, but does not allow for the century "not a leap year"
> and the 400-year "is a leap year".
>
> I have a suspicion that the two wouldn't come together for 14 x 200 =
> 2,800 years. :-(
>
> And will the year 4,000 be a leap year or not? :-)
>
> Regards, Dave S
>
> ________________________________
>
> From: ExcelVBA@yahoogroups.com [mailto:ExcelVBA@yahoogroups.com] On
> Behalf Of Robert E. Carneal
> Sent: Monday, 16 January 2012 05:06
> To: excelvba
> Subject: [ExcelVBA] Datedif and day-of-week?
>
> *If I have Tool Analysis pak installed, how would I determine what the
> day
> of the week is for a date such as January 12, 1805?
>
> One possible way I thought of was to grab the month, day, and add 400 to
> the year. Then use weekday function to get the weekday, however a quick
> test of looking up that date on the Internet and excel show different
> days
> of the week, so I wonder if 400 is the wrong number to use?
>
[Non-text portions of this message have been removed]
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Tidak ada komentar:
Posting Komentar