Worksheet Series Commands - @I Can Do This

Worksheet Series Command
DATE SERIES
Works with OpenOffice or Excel

Start with January 1 and Count By…

One Day

Two Days

Three Days

Four Days

Five Days

Sixe Days

Seven Days

Eight Days

Nine Days

Ten Days

Eleven Days

Twelve Days

1/1

1/1

1/1

1/1

1/1

1/1

1/1

1/1

1/1

1/1

1/1

1/1

1/2

1/3

1/4

1/5

1/6

1/7

1/8

1/9

1/10

1/11

1/12

1/13

1/3

1/5

1/7

1/9

1/11

1/13

1/15

1/17

1/19

1/21

1/23

1/25

1/4

1/7

1/10

1/13

1/16

1/19

1/22

1/25

1/28

1/31

2/3

2/6

1/5

1/9

1/13

1/17

1/21

1/25

1/29

2/2

2/6

2/10

2/14

2/18

1/6

1/11

1/16

1/21

1/26

1/31

2/5

2/10

2/15

2/20

2/25

3/1

1/7

1/13

1/19

1/25

1/31

2/6

2/12

2/18

2/24

3/1

3/7

3/13

1/8

1/15

1/22

1/29

2/5

2/12

2/19

2/26

3/4

3/11

3/18

3/25

1/9

1/17

1/25

2/2

2/10

2/18

2/26

3/5

3/13

3/21

3/29

4/6

1/10

1/19

1/28

2/6

2/15

2/24

3/4

3/13

3/22

3/31

4/9

4/18

1/11

1/21

1/31

2/10

2/20

3/1

3/11

3/21

3/31

4/10

4/20

4/30

1/12

1/23

2/3

2/14

2/25

3/7

3/18

3/29

4/9

4/20

5/1

5/12

1/13

1/25

2/6

2/18

3/1

3/13

3/25

4/6

4/18

4/30

5/12

5/24

1/14

1/27

2/9

2/22

3/6

3/19

4/1

4/14

4/27

5/10

5/23

6/5

Start with January 2 and Count By…

Ones

Twos

Threes

Fours

Fives

Sixes

Sevens

Eights

Nines

Tens

Elevens

Twelves

1/2

1/2

1/2

1/2

1/2

1/2

1/2

1/2

1/2

1/2

1/2

1/2

1/3

1/4

1/5

1/6

1/7

1/8

1/9

1/10

1/11

1/12

1/13

1/14

1/4

1/6

1/8

1/10

1/12

1/14

1/16

1/18

1/20

1/22

1/24

1/26

1/5

1/8

1/11

1/14

1/17

1/20

1/23

1/26

1/29

2/1

2/4

2/7

1/6

1/10

1/14

1/18

1/22

1/26

1/30

2/3

2/7

2/11

2/15

2/19

1/7

1/12

1/17

1/22

1/27

2/1

2/6

2/11

2/16

2/21

2/26

3/2

1/8

1/14

1/20

1/26

2/1

2/7

2/13

2/19

2/25

3/2

3/8

3/14

1/9

1/16

1/23

1/30

2/6

2/13

2/20

2/27

3/5

3/12

3/19

3/26

1/10

1/18

1/26

2/3

2/11

2/19

2/27

3/6

3/14

3/22

3/30

4/7

1/11

1/20

1/29

2/7

2/16

2/25

3/5

3/14

3/23

4/1

4/10

4/19

1/12

1/22

2/1

2/11

2/21

3/2

3/12

3/22

4/1

4/11

4/21

5/1

1/13

1/24

2/4

2/15

2/26

3/8

3/19

3/30

4/10

4/21

5/2

5/13

1/14

1/26

2/7

2/19

3/2

3/14

3/26

4/7

4/19

5/1

5/13

5/25

1/15

1/28

2/10

2/23

3/7

3/20

4/2

4/15

4/28

5/11

5/24

6/6

Start with a date and Count By…

Days

Weeks

Months

Years

Five Years

Ten Years

8/28/1956

8/28/1956

8/28/1956

8/28/1956

8/28/1956

8/28/1956

8/29/1956

8/29/1956

9/28/1956

8/28/1957

8/28/1961

9/7/1956

8/30/1956

8/30/1956

10/28/1956

8/28/1958

8/28/1966

9/17/1956

8/31/1956

8/31/1956

11/28/1956

8/28/1959

8/28/1971

9/27/1956

9/1/1956

9/3/1956

12/28/1956

8/28/1960

8/28/1976

10/7/1956

9/2/1956

9/4/1956

1/28/1957

8/28/1961

8/28/1981

10/17/1956

9/3/1956

9/5/1956

2/28/1957

8/28/1962

8/28/1986

10/27/1956

9/4/1956

9/6/1956

3/28/1957

8/28/1963

8/28/1991

11/6/1956

9/5/1956

9/7/1956

4/28/1957

8/28/1964

8/28/1996

11/16/1956

9/6/1956

9/10/1956

5/28/1957

8/28/1965

8/28/2001

11/26/1956

9/7/1956

9/11/1956

6/28/1957

8/28/1966

8/28/2006

12/6/1956

9/8/1956

9/12/1956

7/28/1957

8/28/1967

8/28/2011

12/16/1956

9/9/1956

9/13/1956

8/28/1957

8/28/1968

8/28/2016

12/26/1956

9/10/1956

9/14/1956

9/28/1957

8/28/1969

8/28/2021

1/5/1957

Find out what day of the week a date fell on…

Date

Type in a series of dates, formatted as Long Date

Tuesday, August 28, 1956

Wednesday, August 29, 1956

Thursday, August 30, 1956

Friday, August 31, 1956

Saturday, September 01, 1956

Sunday, September 02, 1956

Monday, September 03, 1956

Tuesday, September 04, 1956