[AccessD] OT: US/UK public holidays

gustav

As an example
"Public Holiday" "Date"                    "Day Observed"
"Presidents Day" "3rd Monday in February"  "Monday, February 16, 2004"

Date is how the holiday is "defined", "described" or "determined"
and for many ovservance varies year to year.


Date Observed id is for 2004 the calendar day on which it falls.

If You're incorporating into something, I think that You might
need provide the Date Observed for some range of years such as
1900 to 2100. Such data is probably available somewhere on the
web.

Excel does this for it's function WORKDAY(start_date,days,holidays) forcing
the user to provide their own list.

Start_date   is a date that represents the start date. Dates may be entered
as text strings within quotation marks (for example, "1/30/1998" or
"1998/01/30"), as serial numbers (for example, 35825, which represents
January 30, 1998, if you're using the 1900 date system), or as results of
other formulas or functions (for example, DATEVALUE("1/30/1998"))

Days   is the number of nonweekend and nonholiday days before or after
start_date. A positive value for days yields a future date; a negative value
yields a past date.

Holidays   is an optional list of one or more dates to exclude from the
working calendar, such as state and federal holidays and floating holidays.
The list can be either a range of cells that contain the dates or an array
constant of the serial numbers that represent the dates. Learn about array
constants. For more information about how Microsoft Excel uses serial
numbers for dates, see the Remarks section.


Dave

----- Original Message ----- 
From: "Gustav Brock" <gustav at cactus.dk>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Wednesday, April 14, 2004 3:14 PM
Subject: [AccessD] OT: US/UK public holidays


Hi all

What is the meaning of the column "Day Observed" here:

  http://www.usembassy.org.uk/ukpubhol.html

Look for example at the second and third last entry.

/gustav

-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com