Spreadsheet: 76998d1277455473-calculate-dates-with-conditional-formatting-personnel-rotation-2010
Sheet: Calendar

 |  | Jan | Apr | Jul | Oct |  |  |  |  |  |  | Feb | May | Aug | Nov |  |  |  |  | Mar | Jun | Sep | Dec
 |  | 1/1/2010 | 2010-04-01 00:00:00 | 2010-07-01 00:00:00 | 2010-10-01 00:00:00 |  |  |  |  |  | 28 | 2010-02-01 00:00:00 | 2010-05-01 00:00:00 | 2010-08-01 00:00:00 | 2010-11-01 00:00:00 |  |  |  |  | 2010-03-01 00:00:00 | 2010-06-01 00:00:00 | 2010-09-01 00:00:00 | 2010-12-01 00:00:00
Jan |  | 0 | 0 | 0 | 0 | 0 | 1 | 0 | Feb |  | 0 | 1 | 0 | 0 | 0 | 0 | 0 | Mar |  | 0 | 1 | 0 | 0 | 0 | 0 | 0
Apr |  | 0 | 0 | 0 | 0 | 1 | 0 | 0 | May |  | 0 | 0 | 0 | 0 | 0 | 0 | 1 | Jun |  | 0 | 0 | 1 | 0 | 0 | 0 | 0 |  |  | 2003-01-11 00:00:00
Jul |  | 0 | 0 | 0 | 0 | 1 | 0 | 0 | Aug |  | 1 | 0 | 0 | 0 | 0 | 0 | 0 | Sep |  | 0 | 0 | 0 | 1 | 0 | 0 | 0
Oct |  | 0 | 0 | 0 | 0 | 0 | 1 | 0 | Nov |  | 0 | 1 | 0 | 0 | 0 | 0 | 0 | Dec |  | 0 | 0 | 0 | 1 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  | Enter year for calendar: |  |  |  |  |  | 2010 |  |  |  |  | CHANGE THE YEAR HERE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7
 |  | (1900  -  2078)
 |  |  |  |  |  |  |  | CALENDER FOR |  |  |  |  |  |  | 2010
 | JANUARY |  |  |  |  |  |  |  |  | FEBRUARY |  |  |  |  |  |  |  |  | [NAME]
 | WK | SUN | MON | TUE | WED | THU | FRI | SAT |  | WK | SUN | MON | TUE | WED | THU | FRI | SAT |  | WK | SUN | MON | TUE | WED | THU | FRI | SAT
 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 2 |  | 6 | 0 | 1 | 2 | 3 | 4 | 5 | 6 |  | 10 | 0 | 1 | 2 | 3 | 4 | 5 | 6
 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 |  | 7 | 7 | 8 | 9 | 10 | 11 | 12 | 13 |  | 11 | 7 | 8 | 9 | 10 | 11 | 12 | 13
 | 3 | 10 | 11 | 12 | 13 | 14 | 15 | 16 |  | 8 | 14 | 15 | 16 | 17 | 18 | 19 | 20 |  | 12 | 14 | 15 | 16 | 17 | 18 | 19 | 20
 | 4 | 17 | 18 | 19 | 20 | 21 | 22 | 23 |  | 9 | 21 | 22 | 23 | 24 | 25 | 26 | 27 |  | 13 | 21 | 22 | 23 | 24 | 25 | 26 | 27
 | 5 | 24 | 25 | 26 | 27 | 28 | 29 | 30 |  | 10 | 28 | 0 | 0 | 0 | 0 | 0 | 0 |  | 14 | 28 | 29 | 30 | 31 | 0 | 0 | 0
 | 6 | 31 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | APRIL |  |  |  |  |  |  |  |  | MAY |  |  |  |  |  |  |  |  | [NAME]
 | WK | SUN | MON | TUE | WED | THU | FRI | SAT |  | WK | SUN | MON | TUE | WED | THU | FRI | SAT |  | WK | SUN | MON | TUE | WED | THU | FRI | SAT
 | 14 | 0 | 0 | 0 | 0 | 1 | 2 | 3 |  | 18 | 0 | 0 | 0 | 0 | 0 | 0 | 1 |  | 23 | 0 | 0 | 1 | 2 | 3 | 4 | 5
 | 15 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |  | 19 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |  | 24 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 | 16 | 11 | 12 | 13 | 14 | 15 | 16 | 17 |  | 20 | 9 | 10 | 11 | 12 | 13 | 14 | 15 |  | 25 | 13 | 14 | 15 | 16 | 17 | 18 | 19
 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 |  | 21 | 16 | 17 | 18 | 19 | 20 | 21 | 22 |  | 26 | 20 | 21 | 22 | 23 | 24 | 25 | 26
 | 18 | 25 | 26 | 27 | 28 | 29 | 30 | 0 |  | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 |  | 27 | 27 | 28 | 29 | 30 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 23 | 30 | 31 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | JULY |  |  |  |  |  |  |  |  | AUGUST |  |  |  |  |  |  |  |  | SEPTEMBER
 | WK | SUN | MON | TUE | WED | THU | FRI | SAT |  | WK | SUN | MON | TUE | WED | THU | FRI | SAT |  | WK | SUN | MON | TUE | WED | THU | FRI | SAT
 | 27 | 0 | 0 | 0 | 0 | 1 | 2 | 3 |  | 32 | 1 | 2 | 3 | 4 | 5 | 6 | 7 |  | 36 | 0 | 0 | 0 | 1 | 2 | 3 | 4
 | 28 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |  | 33 | 8 | 9 | 10 | 11 | 12 | 13 | 14 |  | 37 | 5 | 6 | 7 | 8 | 9 | 10 | 11
 | 29 | 11 | 12 | 13 | 14 | 15 | 16 | 17 |  | 34 | 15 | 16 | 17 | 18 | 19 | 20 | 21 |  | 38 | 12 | 13 | 14 | 15 | 16 | 17 | 18
 | 30 | 18 | 19 | 20 | 21 | 22 | 23 | 24 |  | 35 | 22 | 23 | 24 | 25 | 26 | 27 | 28 |  | 39 | 19 | 20 | 21 | 22 | 23 | 24 | 25
 | 31 | 25 | 26 | 27 | 28 | 29 | 30 | 31 |  | 36 | 29 | 30 | 31 | 0 | 0 | 0 | 0 |  | 40 | 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 | 0 | 0 | 0
 | OCTOBER |  |  |  |  |  |  |  |  | NOVEMBER |  |  |  |  |  |  |  |  | DECEMBER
 | WK | SUN | MON | TUE | WED | THU | FRI | SAT |  | WK | SUN | MON | TUE | WED | THU | FRI | SAT |  | WK | SUN | MON | TUE | WED | THU | FRI | SAT
 | 40 | 0 | 0 | 0 | 0 | 0 | 1 | 2 |  | 45 | 0 | 1 | 2 | 3 | 4 | 5 | 6 |  | 49 | 0 | 0 | 0 | 1 | 2 | 3 | 4
 | 41 | 3 | 4 | 5 | 6 | 7 | 8 | 9 |  | 46 | 7 | 8 | 9 | 10 | 11 | 12 | 13 |  | 50 | 5 | 6 | 7 | 8 | 9 | 10 | 11
 | 42 | 10 | 11 | 12 | 13 | 14 | 15 | 16 |  | 47 | 14 | 15 | 16 | 17 | 18 | 19 | 20 |  | 51 | 12 | 13 | 14 | 15 | 16 | 17 | 18
 | 43 | 17 | 18 | 19 | 20 | 21 | 22 | 23 |  | 48 | 21 | 22 | 23 | 24 | 25 | 26 | 27 |  | 52 | 19 | 20 | 21 | 22 | 23 | 24 | 25
 | 44 | 24 | 25 | 26 | 27 | 28 | 29 | 30 |  | 49 | 28 | 29 | 30 | 0 | 0 | 0 | 0 |  | 53 | 26 | 27 | 28 | 29 | 30 | 31 | 0
 | 45 | 31 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | LIST OF HOLIDAYS