thanks JLatham,
i will gather your requirement and be in touch very soon.

happy holidays
driller

"JLatham" wrote:

If you can provide dates/rules for determining the holidays (and their names)
in a format kind of like this one given for U.S. Fed holidays:
http://aa.usno.navy.mil/faq/docs/holidays.html


Then we can probably do business <g. The 'fixed date' holidays such as
Christmas and New Years are relatively easy to do, it's the "the first Sunday
after the full moon that occurs on or after the vernal equinox" ones (that's
Easter Sunday, by the way) are tougher.

If the list is short and doesn't need too much back-and-forth bantering, you
could post it here. Otherwise you could send the list to
HelpFrom @ jlathamsite.com (no spaces)
and I'll look into it and can probably have it done in time for Lent.

Now, I'm not up on all the good Catholic holidays, so you'd need to be
specific with regards to which ones you need and probably a hint as to how
they may relate to the primary holiday. Example: Lent and Good Friday are
based on Easter. So I'd need to know #days before Easter that Lent starts,
and (in theory) same for Good Friday.

I've done the standard U.S. holidays for our company's shared calendar, so I
generally have a process to determine such things as 1st or 3rd Monday in a
given month. It's just a matter of implementing the rules in code and
setting it up to be used as a User Defined Function for you to plug into your
workbook.

"dribler2" wrote:

Jlatham
Thanks for your interesting questions
#1. Country. Nicaragua. But i hope we can be availed to adjust the standard
holiday dates.
#2. Same shifting of holi-days, as you mentioned.
#3. Catholic Holidays for Easter included as standard holiday.

hope you can solve mine problem...happy holidays
dribler2

"JLatham" wrote:

I'm going to toss a couple of questions at you before going further.

#1 - define "standard holiday". For what country (USA, I presume, but it's
a world-wide community here)? There are currently 10 recognized U.S. Federal
holidays, and then there are a variety of State holidays - thus my request to
define "standard holiday".

#2 - Do you want the actual date of the holiday or the day it is observed
on? For the Federal holidays in the U.S. the rule is if the holiday falls on
a Saturday, it is observed on the Friday before; if it falls on a Sunday,
then it is observed on the Monday after.

Remember unless you go look them up somewhere, some of the holidays fall on
different dates each year - Thanksgiving in the U.S. being one of those. The
actual day of some like that one is determined as some day of the week after
some other point in time.

#3 - looking for religious holidays also? Some of those are fun. Easter is
fun to compute.

"dribler2" wrote:

i'm short for long formulas, can anyone help me with this.

assuming i have a 20 dates in text format (e.g. "25 DEC", "01 JAN", "01
MAY", etc..) in column X which contains the standard public holidays.
(x1:x20). i made it to 20 yet some cells are blank for any future additions)

and in column A, i have a series of dates for say 6 years, starting from
01/01/2006 down to 12/31/2012

Then, I need to collect the real dates of standard public holidays in column
A (e.g. 01/01/2006,01/01/2007,etc) and place them all in Column C, under a
defined name "holidays"..

surely someone knew this a since long time ago.

any suggestion is welcome.

driller