Counting Dates

[rgwilkinson]

I need to count a series of dates to get frequencey in days per week, then weeks per year. I am using a pivot table but just can't figure out how to count the frequency of a date.

<TABLE style="WIDTH: 78pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=104><COLGROUP><COL style="WIDTH: 78pt; mso-width-source: userset; mso-width-alt: 3803" width=104><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 78pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl64 height=20 width=104>3/26/2007</TD></TR><TR style="HEIGHT: 15pt; mso-outline-level: 1" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl64 height=20>3/26/2007</TD></TR><TR style="HEIGHT: 15pt; mso-outline-level: 1" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl64 height=20>3/26/2007</TD></TR><TR style="HEIGHT: 15pt; mso-outline-level: 1" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl64 height=20>3/27/2007</TD></TR><TR style="HEIGHT: 15pt; mso-outline-level: 1" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl64 height=20>3/27/2007</TD></TR><TR style="HEIGHT: 15pt; mso-outline-level: 1" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl64 height=20>3/27/2007</TD></TR><TR style="HEIGHT: 15pt; mso-outline-level: 1" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl64 height=20>3/28/2007</TD></TR><TR style="HEIGHT: 15pt; mso-outline-level: 1" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl64 height=20>3/28/2007</TD></TR><TR style="HEIGHT: 15pt; mso-outline-level: 1" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl64 height=20>3/28/2007</TD></TR><TR style="HEIGHT: 15pt; mso-outline-level: 1" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl64 height=20>3/28/2007</TD></TR><TR style="HEIGHT: 15pt; mso-outline-level: 1" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl64 height=20>3/28/2007</TD></TR><TR style="HEIGHT: 15pt; mso-outline-level: 1" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl64 height=20>3/29/2007</TD></TR><TR style="HEIGHT: 15pt; mso-outline-level: 1" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl64 height=20>3/29/2007</TD></TR><TR style="HEIGHT: 15pt; mso-outline-level: 1" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl64 height=20>3/29/2007</TD></TR><TR style="HEIGHT: 15pt; mso-outline-level: 1" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl64 height=20>3/30/2007</TD></TR><TR style="HEIGHT: 15pt; mso-outline-level: 1" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl64 height=20>3/30/2007</TD></TR><TR style="HEIGHT: 15pt; mso-outline-level: 1" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl64 height=20>3/30/2007</TD></TR><TR style="HEIGHT: 15pt; mso-outline-level: 1" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl64 height=20>3/30/2007</TD></TR></TBODY></TABLE>

 

[venkat1926]

see sheet below. the main data(a1 to A19 with column heading) was advance filtered to get unique dates in cells no. A25 and below and then see the formula in B26 which is copied down;.(this is one way of doing it)

Excel Workbook
	A	B
1	hndg1
2	3/26/2007
3	3/26/2007
4	3/26/2007
5	3/27/2007
6	3/27/2007
7	3/27/2007
8	3/28/2007
9	3/28/2007
10	3/28/2007
11	3/28/2007
12	3/28/2007
13	3/29/2007
14	3/29/2007
15	3/29/2007
16	3/30/2007
17	3/30/2007
18	3/30/2007
19	3/30/200
20
21
22
23
24
25	hndg1
26	3/26/2007	3
27	3/27/2007	3
28	3/28/2007	5
29	3/29/2007	3
30	3/30/2007	3
31	3/30/200	1
Sheet1

 

[rgwilkinson]

I'm looking for days per week and weeks per year of an event. Not the frequency of a day