YearlyCalendar YearlyCalendar ©2005Vertex42,LLC Vertex42.com Year 2005 Year: Month 1 Month: YearlyCalendar January2005-December2005 January2005 1 February2005 2 March2005 3 S M T W Th F Sa S M T W Th F Sa S M T W Th F Sa 0 0 0 0 0 0 1 0 0 1 2 3 4 5 0 0 1 2 3 4 5 2 3 4 5 6 7 8 6 7 8 9 10 11 12 6 7 8 9 10 11 12 9 10 11 12 13 14 15 13 14 15 16 17 18 19 13 14 15 16 17 18 19 16 17 18 19 20 21 22 20 21 22 23 24 25 26 20 21 22 23 24 25 26 23 24 25 26 27 28 29 27 28 0 0 0 0 0 27 28 29 30 31 0 0 30 31 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 April2005 4 May2005 5 June2005 6 S M T W Th F Sa S M T W Th F Sa S M T W Th F Sa 0 0 0 0 0 1 2 1 2 3 4 5 6 7 0 0 0 1 2 3 4 3 4 5 6 7 8 9 8 9 10 11 12 13 14 5 6 7 8 9 10 11 10 11 12 13 14 15 16 15 16 17 18 19 20 21 12 13 14 15 16 17 18 17 18 19 20 21 22 23 22 23 24 25 26 27 28 19 20 21 22 23 24 25 24 25 26 27 28 29 30 29 30 31 0 0 0 0 26 27 28 29 30 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 July2005 7 August2005 8 September2005 9 S M T W Th F Sa S M T W Th F Sa S M T W Th F Sa 0 0 0 0 0 1 2 0 1 2 3 4 5 6 0 0 0 0 1 2 3 3 4 5 6 7 8 9 7 8 9 10 11 12 13 4 5 6 7 8 9 10 10 11 12 13 14 15 16 14 15 16 17 18 19 20 11 12 13 14 15 16 17 17 18 19 20 21 22 23 21 22 23 24 25 26 27 18 19 20 21 22 23 24 24 25 26 27 28 29 30 28 29 30 31 0 0 0 25 26 27 28 29 30 0 31 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 October2005 10 November2005 11 December2005 12 S M T W Th F Sa S M T W Th F Sa S M T W Th F Sa 0 0 0 0 0 0 1 0 0 1 2 3 4 5 0 0 0 0 1 2 3 2 3 4 5 6 7 8 6 7 8 9 10 11 12 4 5 6 7 8 9 10 9 10 11 12 13 14 15 13 14 15 16 17 18 19 11 12 13 14 15 16 17 16 17 18 19 20 21 22 20 21 22 23 24 25 26 18 19 20 21 22 23 24 23 24 25 26 27 28 29 27 28 29 30 0 0 0 25 26 27 28 29 30 31 30 31 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0LimitedUsePolicyThespreadsheetisforyourpersonaluseonly.Youmaycustomizeittosuityourneeds,butitmaynotbesold,distributed,orplacedonapublicserver(i.e.theinternet),withoutthewrittenconsentofVertex42LLC.NoWarrantiesTHESOFTWAREANDANYRELATEDDOCUMENTATIONAREPROVIDEDTOYOU"ASIS."VERTEX42,LLCMAKESNOWARRANTIES,EXPRESSORIMPLIED,ANDEXPRESSLYDISCLAIMSALLREPRESENTATIONS,ORALORWRITTEN,TERMS,CONDITIONS,ANDWARRANTIES,INCLUDINGBUTNOTLIMITEDTO,IMPLIEDWARRANTIESOFMERCHANTABILITY,FITNESSFORAPARTICULARPURPOSE,ANDNONINFRINGEMENT.WITHOUTLIMITINGTHEABOVEYOUACCEPTTHATTHESOFTWAREMAYNOTMEETYOURREQUIREMENTS,OPERATEERRORFREE,ORIDENTIFYANYORALLERRORSORPROBLEMS,ORDOSOACCURATELY.ThisAgreementdoesnotaffectanystatutoryrightsyoumayhaveasaconsumer.Somestatesdonotallowthelimitationorexclusionofliabilityforincidentalorconsequentialdamages,sotheabovelimitationmaynotapplytoyou.LimitationofLiabilityINNOEVENTSHALLVERTEX42,LLCBELIABLETOYOU,FORANYDAMAGES,INCLUDINGANYLOSTPROFITS,LOSTSAVINGS,ORANYOTHERDIRECT,INDIRECT,SPECIAL,INCIDENTAL,ORCONSEQUENTIALDAMAGESARISINGFROMTHEUSEORTHEINABILITYTOUSETHESOFTWARE(EVENIFWEORANAUTHORIZEDDEALERORDISTRIBUTORHASBEENADVISEDOFTHEPOSSIBILITYOFTHESEDAMAGES),ORANYMISTAKESANDNEGLIGENCEINDEVELOPINGTHISSOFTWARE,ORFORANYCLAIMBYANYOTHERPARTY.THEORGANIZATION,BUSINESS,ORPERSONUSINGTHISSOFTWAREBEARSALLRISKSANDRESPONSIBILITYFORTHEQUALITYANDPERFORMANCEOFTHISSOFTWARE.Somesstatesdonotallowthelimitationorexclusionofliabilityforincidentalorconsequentialdamages,sotheabovelimitationmaynotapplytoyou.©2005Vertex42,LLCVertex42.comFormulas DateFormulas Months startDate 1/1/05 January February March April May June July August September October November December Methodforcreatingamonthlycalendarwithoutusingarrays Usingarrays January2005 Sun Mon Tue Wed Thu Fri Sat January2005 1 2 3 4 5 6 7 S M T W Th F Sa 1 31 31 31 31 31 31 1 0 0 0 0 0 0 1 2 2 3 4 5 6 7 8 2 3 4 5 6 7 8 3 9 10 11 12 13 14 15 9 10 11 12 13 14 15 4 16 17 18 19 20 21 22 16 17 18 19 20 21 22 5 23 24 25 26 27 28 29 23 24 25 26 27 28 29 6 30 31 31 31 31 31 31 30 31 0 0 0 0 0 monthNames startDates January 1/1/05 February 2/1/05 March 3/1/05 April 4/1/05 May 5/1/05 June 6/1/05 July 7/1/05 August 8/1/05 September 9/1/05 October 10/1/05 November 11/1/05 December 12/1/05 January 1/1/06 February 2/1/06 March 3/1/06 April 4/1/06 May 5/1/06 June 6/1/06 July 7/1/06 August 8/1/06 September 9/1/06 October 10/1/06 November 11/1/06 December 12/1/06 January 1/1/07 February 2/1/07Addingadditionalmonths:Insertanewrow(beforethelastmonthinthelist)andcopytheformulasdown.NamedArray:Thecalendarsreferencethisarray,namedmonthNames=INDEX(monthNames,3)willreturnthethirdmonthinthearray.NamedArray:Thecalendarsreferencethisarray,namedstartDates=INDEX(startDates,3)willreturnthedatecorrespondingtothethirddateinthelist,whichisthedateforthefirstdayofthemonth.HowitWorks:Thiscalendarisincludedtoshowhowthemorecomplexarrayfunctionworks.Notetheuseofmixedabsoluteandrelativereferencesthatenableyoutocopytheformuladownandacross.Thisisbasicallywhatthearrayformulaisdoingforyou.MonthNames:Thisnamedrange(months)isusedastheinputforthecombobox.TheStartDate:Thisnamedformula(startDate)isthefirstdayofthefirstmonthintheyearlycalendar,definedbythemonthandyearchosenbytheuser.