very cool -----Original Message----- From: Alan Frayer [mailto:[EMAIL PROTECTED] Sent: Friday, January 27, 2006 10:21 AM To: [email protected] Subject: Re: [users] Perpetial Calendar Calc Sheet
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. > > I'm impressed. Would this count as a template, even though it isn't technically one? I think the Documentation project might like it, if you're willing to contribute it. -- Alan Frayer [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
