1、Yearly CalendarJuly 2012-June 2013July 201271August 201282September 201293SMTWThFSaSMTWThFSaSMTWThFSa1234567123418910111213145678910112345678151617181920211213141516171891011121314152223242526272819202122232425161718192021222930312627282930312324252627282930October 2012104November 2012115December 20
2、12126SMTWThFSaSMTWThFSaSMTWThFSa1234561231789101112134567891023456781415161718192011121314151617910111213141521222324252627181920212223241617181920212228293031252627282930232425262728293031January 201317February 201328March 201339SMTWThFSaSMTWThFSaSMTWThFSa1234512126789101112345678934567891314151617
3、18191011121314151610111213141516202122232425261718192021222317181920212223272829303124252627282425262728293031April 2013410May 2013511June 2013612SMTWThFSaSMTWThFSaSMTWThFSa1234561234178910111213567891011234567814151617181920121314151617189101112131415212223242526271920212223242516171819202122282930
4、2627282930312324252627282930Date FormulasMonthsstartDate2012/7/1JanuaryFebruaryMarchAprilMayJuneJulyAugustSeptemberOctoberNovemberDecemberMethod for creating a monthly calendar without using arraysUsing arraysJuly 2012SunMonTueWedThuFriSatJuly 20121234567S11234567128910111213148315161718192021154222
5、32425262728225293031296monthNamesstartDatesJuly2012/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/1December
6、2013/12/1January2014/1/1February2014/2/1March2014/3/1April2014/4/1May2014/5/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
7、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.June2014/6/1July2014/7/1August2014/8/1Adding additional months:Insert a new row(before thelast month in the list)andcopy the formulas down.MTWThFSa234567910111213141617181920212324252627283031Using arraysJuly 2012