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?
*
*Thank you.
**Robert*
*Genealogy without documentation is mythology! Always SOURCE your work.*
[Non-text portions of this message have been removed]
----------
Visit our website at http://www.ubs.com
This message contains confidential information and is intended only
for the individual named. If you are not the named addressee you
should not disseminate, distribute or copy this e-mail. Please
notify the sender immediately by e-mail if you have received this
e-mail by mistake and delete this e-mail from your system.
E-mails are not encrypted and cannot be guaranteed to be secure or
error-free as information could be intercepted, corrupted, lost,
destroyed, arrive late or incomplete, or contain viruses. The sender
therefore does not accept liability for any errors or omissions in the
contents of this message which arise as a result of e-mail transmission.
If verification is required please request a hard-copy version. This
message is provided for informational purposes and should not be
construed as a solicitation or offer to buy or sell any securities
or related financial instruments.
UBS reserves the right to retain all messages. Messages are protected
and accessed only in legally justified cases.
[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