Dates, Conversions, and Histograms Questions

Tech-Archive recommends: Speed Up your PC by fixing your registry

Some questions.
1. if A1 = 1/5/2005 (date format), is there a function that converts A1 to the day of the year, 5?
2. Suppose the date conversion in 1 is dayofyear(A1). I have a whole column of dates, how can I easily produce a column of
=dayofyear(a1)
=dayofyear(a2)
....
=dayofyear(a20)

3. Suppose I want a count of all the occurrences of events in a week and want to produce a histogram for a 20 week period, is there a way to do it?

For example, assuming 1/1/2008 is a Monday, and is the considered the first day of the week, I have this data.
Date
1/4/2008
1/6/2008
1/6/2008
1/6/2008
1/7/2008
1/8/2008
1/8/2008
1/10/2008
1/14/2008
.... (2 weeks of no data)
1/29/2008
1/30/2008
1/30/2008
2/10/2008
....

My histogram should start off like this:

Week 1: 5 (frequency in first week)
Week 2: 4 (second week)
Week 3: 0 --this may not be possible under the scheme above
Week 4: 0 ditto
Week 5: 3 (fifth week)

--
             Wayne T. Watson (Watson Adventures, Prop., Nevada City, CA)
                 (121.015 Deg. W, 39.262 Deg. N) GMT-8 hr std. time)
                  Obz Site:  39° 15' 7" N, 121° 2' 32" W, 2700 feet

                     "Academic disputes are vicious because so little
                      is at stake." -- Anonymous

                        Web Page: <home.earthlink.net/~mtnviews>

.

Relevant Pages