当日计划模板英文.xls

14二月,2010SundayValentines DayW06-7RememberAppointmentsNotesMom&Dads Anniversary7:00Birthdays:Ted&Mary:308:00:15:30:459:00:15:30:4510:00ABCPrioritized Task List:15:30:4511:00:15:30:4512:00:15:30:451:00:15:30:452:00:15:30TimePeople to Call:453:00:15:30:454:00:15:30:455:00$AmtExpenses:306:00:307:00:308:00:309:00:30Su MTu WThFSa12345678910 11 12 13 14 15 1617 18 19 20 21 22 2324 25 26 27 28 29 3031January 2010Su MTu WThFSa12345678910 11 12 1314 15 16 17 18 19 2021 22 23 24 25 26 2728February 2010Su MTu WThFSa12345678910 11 12 1314 15 16 17 18 19 2021 22 23 24 25 26 2728 29 30 31March 2010 2009 Vertex42 LLC and Special EventsCurrent Year2010Current Month2Holiday/EventMonthDayWeekWeekDayDateNotesTaxes Due4152010/4/15If 15th is a Sun or Sat,then taxes are due the following MondayDaylight Savings413/14/10 2nd Sunday in March(starting in 2007),1st Sunday in April(prior to 2007)Daylight Savings11111/7/10 1st Sunday of November(starting in 2007),Last Sunday in October(prior to 2007)Grandparents Day2010/9/12 1st Sunday after Labor DayAdmin Assist Day442010/4/21 Wednesday of last full week in AprilML King Day1321/17/11 3rd Monday of JanuaryHolidays and Events Occuring on Specific Days of the WeekThanksgiving114511/25/104th Thursday of NovemberML King Day1321/18/103rd Monday of JanuaryMothers Day5215/9/102nd Sunday of MayFathers Day6316/20/103rd Sunday of JuneParents Day7417/25/104th Sunday in JulyLabor Day9129/6/101st Monday of SeptemberPresidents Day2322/15/103rd Monday of FebruaryColumbus Day102210/11/102nd Monday of OctoberMemorial Day6025/31/10Last Monday of MayHolidays and Events Occuring on a Specific DateHalloween10312010/10/31Christmas Day12252010/12/25Christmas Eve12242010/12/24New Years Eve12312010/12/31New Years Day112010/1/1St.Patricks Day3172010/3/17April Fools Day412010/4/1Flag Day6142010/6/14Independence Day742010/7/4Veterans Day11112010/11/11Groundhog Day222010/2/2Lincolns B-Day2122010/2/12Valentines Day2142010/2/14Earth Day4222010/4/22United Nations Day10242010/10/24Instructions and Notes:Adding Holidays and Special EventsTo add new events,copy a row containing an example of thedate formula that you wish to use and then modify themonth/day or week/weekday as needed.Calendar Will Only Show up to 2 Holidays/Events Per DayDeleting EventsTo delete or remove events,just delete the entire row.Ordelete the event name(in column A)if you want to keep aformula in the date column for later reference.Floating Holidays/Events(e.g.3rd Sunday of.)Floating holidays and events are those that occur on specificdays of the month,like the 3rd Sunday of.-Week=1,WeekDay=2 for the 1st Monday of the month-Week=3,WeekDay=1 for the 3rd Sunday of the month-Month=2,Week=0,WeekDay=2 for the last Monday in theprevious month(January in this case).-Month=2,Week=-1,WeekDay=2 for the 2nd to last Mondayin January(another tricky one)Additional Notes:-Column A is named arr_event and is the text displayed onthe calendar.-Column F is named arr_eventdate and the date calculatedin this column is used to determine where to place the event onthe calendar.-Columns D(week)and E(WeekDay)are for calculatingfloating holidays.For example,Thanksgiving is on the 4thThursday of November.-Columns B(month)and C(Day)are for calculating thedate using DATE(year,month,day).-If 2 or more events or holidays occur on the same day,then the one listed FIRST will be the one shown first on thecalendar.-The DATE()formula only works AFTER 1900.If 15th is a Sun or Sat,then taxes are due the following Monday2nd Sunday in March(starting in 2007),1st Sunday in April(prior to 2007)1st Sunday of November(starting in 2007),Last Sunday in October(prior to 2007)Birthdays,AnniversariesCopy the formula in the Date column when adding new birthdays/anniversariesDescriptionMonthDayDateThere is a limit of 3 events per day,so combine into a single description if neededMom&Dads Anniversary2142010/2/14Birthdays:Ted&Mary2142010/2/14Copy the formula in the Date column when adding new birthdays/anniversariesThere is a limit of 3 events per day,so combine into a single description if neededMini CalendarsStart Day1WeekNo1:Sunday first2:Monday first(ISO)一月 2010WkSuMTuWThFSaThese dates and those in the Events sheet must be formatted the same way5312134567892010/1/32010/1/42010/1/52010/1/62010/1/7210 11 12 13 14 15 162010/1/102010/1/112010/1/122010/1/132010/1/14317 18 19 20 21 22 232010/1/172010/1/182010/1/192010/1/202010/1/21424 25 26 27 28 29 302010/1/242010/1/252010/1/262010/1/272010/1/284312010/1/31二二月月 20102010WkSuMTuWThFSa51234562010/2/12010/2/22010/2/32010/2/4678910 11 12 132010/2/72010/2/82010/2/92010/2/102010/2/11714 15 16 17 18 19 202010/2/142010/2/152010/2/162010/2/172010/2/18821 22 23 24 25 26 272010/2/212010/2/222010/2/232010/2/242010/2/258282010/2/28三月 2010WkSuMTuWThFSa91234562010/3/12010/3/22010/3/32010/3/41078910 11 12 132010/3/72010/3/82010/3/92010/3/102010/3/111114 15 16 17 18 19 202010/3/142010/3/152010/3/162010/3/172010/3/181221 22 23 24 25 26 272010/3/212010/3/222010/3/232010/3/242010/3/251328 29 30 312010/3/282010/3/292010/3/302010/3/31ISOUS:Use Start Day=1(Sunday).Week 1 contains January 1ISO:Must use Start Day=2(Monday).Week 1 contains the first ThursdayNote:When using the US week number,you must have the Analysis ToolPak add-in installed2010/1/12010/1/22010/1/82010/1/92010/1/152010/1/162010/1/222010/1/232010/1/292010/1/302010/2/52010/2/62010/2/122010/2/132010/2/192010/2/202010/2/262010/2/272010/3/52010/3/62010/3/122010/3/132010/3/192010/3/202010/3/262010/3/27These dates and those in the Events sheet must be formatted the same way