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. -- Dennis Marks --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
