Convert Dates

  • Thread starter Thread starter Carlos
  • Start date Start date
C

Carlos

I am trying to aggragate dates using a pivot table by
month. The problem is that I have multiple dates- for
example

Date Value
1/01/03 3
1/01/03 9
1/02/03 1
2/18/03 1
2/17/03 1

When I try to use a pivot table, these dates are not
aggregated by month. I end up with 3 entries for Jan and
two for Feb. When I really want to see 1 entry for Jan
with a total value of 13 and Feb with a total value 2.

In other words, I dont want to consider the day only the
month and year.

Thank you,

Carlos
 
I am trying to aggragate dates using a pivot table by
month. The problem is that I have multiple dates- for
example

Date Value
1/01/03 3
1/01/03 9
1/02/03 1
2/18/03 1
2/17/03 1

When I try to use a pivot table, these dates are not
aggregated by month. I end up with 3 entries for Jan and
two for Feb. When I really want to see 1 entry for Jan
with a total value of 13 and Feb with a total value 2.

In other words, I dont want to consider the day only the
month and year.

Thank you,

Carlos
Click to expand...

From HELP for "pivot table group"

Right-click the field with the dates or times, point to Group and Show Details
on the shortcut menu, and then click Group.

Enter the first date or time to group in the Starting at box, and enter the
last date or time to group in the Ending at box.

In the By box, click one or more time periods for the groups.

To group items by weeks, click Days in the By box, make sure Days is the only
time period selected, and then click 7 in the Number of days box. You can then
click additional time periods to group by, such as Month, if you want.


--ron
 
Back
Top