Printable Daily Planner Macros

3
March, 2011
Thursday
February 2011
Su
6
W09-4
Remember
March 2011
M Tu W Th
7
F Sa
4
10 11 12
April 2011
Su M Tu W Th
6
F Sa
4
Su
M Tu W Th
10 11 12
F Sa
1
13 14 15 16 17 18 19
13 14 15 16 17 18 19
10 11 12 13 14 15 16
20 21 22 23 24 25 26
20 21 22 23 24 25 26
17 18 19 20 21 22 23
27 28
27 28 29 30 31
24 25 26 27 28 29 30
Appointments
Notes
7 :00
:30
8 :00
:15
:30
:45
9 :00
:15
:30
:45
ABC
Prioritized Task List
10 :00
:15
:30
:45
11 :00
:15
:30
:45
12 :00
:15
:30
:45
1 :00
:15
:30
:45
2 :00
:15
:30
Time
People to Call
:45
3 :00
:15
:30
:45
4 :00
:15
:30
:45
$Amt
Expenses
5 :00
:30
6 :00
:30
7 :00
:30
8 :00
:30
9 :00
:30
2009 Vertex42 LLC
www.vertex42.com/calendars/
2009 Vertex42 LLC
www.vertex42.com/calendars/
Holidays and Special Events

Current Year
Current Month
Holiday/Event
Taxes Due
Daylight Savings
Daylight Savings
Grandparents Day
Admin Assist Day
ML King Day
2011
3
Month
4
4
11
Day
15
Week WeekDay
Date
4/15/2011 If
1
1
Notes
15th is a Sun or Sat, then taxes are due the following
3/13/11 2nd Sunday in March (starting in 2007), 1st Sunday in April (prior to 2
11/6/11 1st Sunday of November (starting in 2007), Last Sunday in October (

9/11/2011 1st Sunday after Labor Day
4
1
4
2
4/27/2011 Wednesday of last full week in April

1/16/12 3rd Monday of January
Holidays and Events Occuring on Specific Days of the Week

Thanksgiving
11
4
5
11/24/11 4th Thursday of November
ML King Day
1
3
2
1/17/11 3rd Monday of January
Mother's Day
5
2
1
5/8/11 2nd Sunday of May
Father's Day
6
3
1
6/19/11 3rd Sunday of June
Parents' Day
7
4
1
7/24/11 4th Sunday in July
Labor Day
9
1
2
9/5/11 1st Monday of September
President's Day
2
3
2
2/21/11 3rd Monday of February
Columbus Day
10
2
2
10/10/11 2nd Monday of October
Memorial Day
6
0
2
5/30/11 Last Monday of May
Holidays and Events Occuring on a Specific Date

Halloween
10
31
Christmas Day
12
25
Christmas Eve
12
24
New Year's Eve
12
31
New Year's Day
1
1
St. Patrick's Day
3
17
April Fool's Day
4
1
Flag Day
6
14
Independence Day
7
4
Veterans Day
11
11
Groundhog Day
2
2
Lincoln's B-Day
2
12
Valentines Day
2
14
Earth Day
4
22
United Nations Day
10
24
10/31/2011
12/25/2011
12/24/2011
12/31/2011
1/1/2011
3/17/2011
4/1/2011
6/14/2011
7/4/2011
11/11/2011
2/2/2011
2/12/2011
2/14/2011
4/22/2011
10/24/2011
at, then taxes are due the following Monday
arting in 2007), 1st Sunday in April (prior to 2007)

(starting in 2007), Last Sunday in October (prior to 2007)
Instructions and Notes:

Adding Holidays and Special Events
To add new events, copy a row containing an example of the
date formula that you wish to use and then modify the
month/day or week/weekday as needed.
Calendar Will Only Show up to 2 Holidays/Events Per
Day
Deleting Events
To delete or remove events, just delete the entire row. Or
delete the event name (in column A) if you want to keep a
formula in the date column for later reference.
Floating Holidays/Events (e.g. 3rd Sunday of ...)
Floating holidays and events are those that occur on specific
days 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 the
previous month (January in this case).
- Month=2, Week=-1, WeekDay=2 for the 2nd to last Monday
in January (another tricky one)
Additional Notes:
-- Column A is named "arr_event" and is the text displayed on
the calendar.
-- Column F is named "arr_eventdate" and the date calculated
in this column is used to determine where to place the event on
the calendar.
-- Columns D (week) and E (WeekDay) are for calculating
floating holidays. For example, Thanksgiving is on the 4th
Thursday of November.
-- Columns B (month) and C (Day) are for calculating the
date 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 the
calendar.
-- The DATE() formula only works AFTER 1900.
Birthdays, Anniversaries
Description
Mom&Dad's Anniversary
Birthdays: Ted & Mary
Month
2
2
Day
14
14
Date
2/14/2011
2/14/2011
Copy the formula in the Date column when adding n

There is a limit of 3 events per day, so combine into
he Date column when adding new birthdays / anniversaries

vents per day, so combine into a single description if needed
Mini Calendars
Start Day
1
1: Sunday first
2: Monday first (ISO)
WeekNo
February 2011
Wk Su M Tu W Th
5
Sa
5
These dates and those in the Events sheet must be formatted the same way
2/1/2011
2/2/2011
2/3/2011
2/7/2011
2/8/2011
2/9/2011
2/10/2011
13 14 15 16 17 18 19
2/13/2011
2/14/2011
2/15/2011
2/16/2011
2/17/2011
20 21 22 23 24 25 26
2/20/2011
2/21/2011
2/22/2011
2/23/2011
2/24/2011
27 28
2/27/2011
2/28/2011
3/1/2011
3/2/2011
3/3/2011
10 11 12
3/6/2011
3/7/2011
3/8/2011
3/9/2011
3/10/2011
11
13 14 15 16 17 18 19
3/13/2011
3/14/2011
3/15/2011
3/16/2011
3/17/2011
12
20 21 22 23 24 25 26
3/20/2011
3/21/2011
3/22/2011
3/23/2011
3/24/2011
13
27 28 29 30 31
3/27/2011
3/28/2011
3/29/2011
3/30/2011
3/31/2011
2/6/2011
10 11 12
March 2011
Wk Su M Tu W Th
9
10
Sa
April 2011
Wk Su M Tu W Th
Sa
13
14
4/3/2011
4/4/2011
4/5/2011
4/6/2011
4/7/2011
15
10 11 12 13 14 15 16
4/10/2011
4/11/2011
4/12/2011
4/13/2011
4/14/2011
16
17 18 19 20 21 22 23
4/17/2011
4/18/2011
4/19/2011
4/20/2011
4/21/2011
17
24 25 26 27 28 29 30
4/24/2011
4/25/2011
4/26/2011
4/27/2011
4/28/2011
ISO
US :: Use Start Day=1 (Sunday). Week 1 contains January 1
ISO :: Must use Start Day=2 (Monday). Week 1 contains the first Thursday
Note: When using the US week number, you must have the Analysis ToolPak add-in installed
formatted the same way

2/4/2011
2/5/2011
2/11/2011
2/12/2011
2/18/2011
2/19/2011
2/25/2011
2/26/2011
3/4/2011
3/5/2011
3/11/2011
3/12/2011
3/18/2011
3/19/2011
3/25/2011
3/26/2011
4/1/2011
4/2/2011
4/8/2011
4/9/2011
4/15/2011
4/16/2011
4/22/2011
4/23/2011
4/29/2011
4/30/2011

Printable Daily Planner Macros

Uploaded by

Copyright:

Available Formats

Printable Daily Planner Macros

Uploaded by

Document Information

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Printable Daily Planner Macros

Uploaded by

Copyright:

Available Formats

3

Prioritized Task List

2009 Vertex42 LLC

2009 Vertex42 LLC

Holidays and Special Events

11/6/11 1st Sunday of November (starting in 2007), Last Sunday in October (

4/27/2011 Wednesday of last full week in April

Holidays and Events Occuring on Specific Days of the Week

Holidays and Events Occuring on a Specific Date

at, then taxes are due the following Monday

arting in 2007), 1st Sunday in April (prior to 2007)

Instructions and Notes:

Copy the formula in the Date column when adding n

he Date column when adding new birthdays / anniversaries

formatted the same way

You might also like