Yep, me too. Top Marks young Marks! I'm now adding in UK holidays.
ps We don't have as many as you - Do you have to work on those dates or is US one big holiday? :-P
WSP
Anthony Chilco wrote:
Very cool Dennis. I added my family's birthdays and it seems to work fine.
tc

Dennis Marks wrote:

I have created a perpetual calendar using Calc. It probably has been done before but I did it for the challenge. It consists of 2 sheets. The first is a template for 1 month. You enter a month number and year and the calendar is created dynamically using formulas. There are no macros. The calendar displays holidays that are on the 2nd sheet. The second sheet contains a list of holidays. The dates are generated based on the year entered on the 1st sheet. It has fixed holidays, holidays that are 1st, 2nd, etc. week of month, and holidays related to Easter.

The calendar displays up to 2 holidays for a single date. The second search was a challenge.

You can find it at http://www.dcsi.net/~denmarks/Calendar.ods. IE will changed it to a zip file when downloaded so you will have to rename it back to ods. Let me know of any errors or comments.




---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]




--
OOo 2.0.1 – SeaMonkey 1.5a/1.0b (nightlies...) - Win XP sp2
==============================================
http://www.answersingenesis.org/

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to