Thanks Dennis, That's very cool. I've been looking for something like this. You rock!
On 1/27/06, Wangshanpo <[EMAIL PROTECTED]> wrote: > > 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] > > -- - Chad Smith http://www.gimpshop.net/ Because everyone loves free software!
