2012自动日历模板.xls

Yearly CalendarJanuary 2012-December 2012January 20121February 20122March 20123SMTWThFSaSMTWThFSaSMTWThFSa12345671234123891011121314567891011456789101516171819202112131415161718111213141516172223242526272819202122232425181920212223242930312627282925262728293031April 20124May 20125June 20126SMTWThFSaSMTWThFSaSMTWThFSa12345671234512891011121314678910111234567891516171819202113141516171819101112131415162223242526272820212223242526171819202122232930272829303124252627282930July 20127August 20128September 20129SMTWThFSaSMTWThFSaSMTWThFSa1234567123418910111213145678910112345678151617181920211213141516171891011121314152223242526272819202122232425161718192021222930312627282930312324252627282930October 201210November 201211December 201212SMTWThFSaSMTWThFSaSMTWThFSa1234561231789101112134567891023456781415161718192011121314151617910111213141521222324252627181920212223241617181920212228293031252627282930232425262728293031Date FormulasMonthsstartDate2012/1/1JanuaryFebruaryMarchAprilMayJuneJulyAugustSeptemberOctoberNovemberDecemberMethod for creating a monthly calendar without using arraysUsing arraysJanuary 2012SunMonTueWedThuFriSatJanuary 20121234567S1123456712891011121314831516171819202115422232425262728225293031296monthNamesstartDatesJanuary2012/1/1February2012/2/1March2012/3/1April2012/4/1May2012/5/1June2012/6/1July2012/7/1August2012/8/1September2012/9/1October2012/10/1November2012/11/1December2012/12/1January2013/1/1February2013/2/1March2013/3/1April2013/4/1May2013/5/1June2013/6/1July2013/7/1August2013/8/1September2013/9/1October2013/10/1November2013/11/1Adding additional months:Insert a new row(before thelast month in the list)andcopy the formulas down.How it Works:This calendar is included to show how themore complex array function works.Note theuse of mixed absolute and relativereferences that enable you to copy theformula down and across.This is basicallywhat the array formula is doing for you.Month Names:This named range(months)is used as the input for thecombo box.The Start Date:This named formula(startDate)isthe first day of the first month inthe yearly calendar,defined by themonth and year chosen by theuser.December2013/12/1January2014/1/1February2014/2/1Adding additional months:Insert a new row(before thelast month in the list)andcopy the formulas down.MTWThFSa234567910111213141617181920212324252627283031Using arraysJanuary 2012