>>Hi everybody,
>>
>>I'm sure, somebody already wrote a program, which will create a list of US Holidays for given year to insert into Holidays table. Could you please share it with me, so I don't need to re-invent it?
>>
>>We store just 8 Holidays:
>>New Year
>>Presidents Day
>>Memorial Day
>>Independance Day
>>Labor Day
>>Columbus Day
>>Thanksgiving
>>Christmas
>>
>>Unfortunately, I'm not sure in these Holidays definitions, where can I find some info?
>>
>>Thanks in advance.
>
>Nadya,
> I ran into this problem myself. I didn't find a VFP solution, but I did create a lookup table from Xcel. I put some starting dates in the first row and the next date I needed in the second. I then used the series function to put in the full range. About 5 years worth. Then after that I was told to skip the holidays. I used the work day and holiday function to modify the sheet. I verified the dates with a freebie app on my Palm. Converted the speadsheet to VFP and have been using the lookup table since last year.
>
> My Palm dropped its batteries so I lost the name of that proggie. I'm gonna restore it Real Soon Now, but I can get it if you want. As far as the exact procedure in Excel, I can also work that up if you feel it's what you might need.
>
>HTH,
>Pete
This would be really great. For year 2002 I would create them manually, but I'd love to have it automated...
If it's not broken, fix it until it is.
My Blog