🚀 go-pugleaf

Hi Dave!

I have run up against this problem in the past when trying to make data
tables of SEX vs. AGE, where I wanted AGE to be say, <18, 18-25, 26-30, 
etc., much as you want your dates to be 15Jun92-14Jul92, 15Jul92-14Aug92,
etc., as I understand it.  The only solution I was ever able to come up
with was to create another column next to the AGE column, called "AGEGRP",
where I used a lookup table to assign values based on which range the age
fell into.  For example:

  |  A   |   B   |   C   |   D   |   E   |
--|------|-------|-------|-------|-------|
1 | AGE  | AGEGrp|       | lookup table  |
2 |  15  |   1   |       |  17   |   1   |
3 |  22  |   2   |       |  25   |   2   |
4 |  21  |   2   |       |  30   |   3   |
5 |  43  |   6   |       |  35   |   4   |
6 |  17  |   1   |       |  40   |   5   |
7 |  39  |   4   |       |  45   |   6   |

Where the formulas in column B would be fashioned after 
B2: @vlookup(A2,$table,1), and the range named "table" is 
D2..E7.  Having done this, you can run /Data Table on the
values in column B rather than column A, knowing that 
AgeGrp=1 means Age<18, AgeGrp=2 means Age is 18-25, etc.

This same idea could be applied to your date dilemma.
Use a formula to create a column of date values equal
to the 15th of every month for the given year.  Then use
the same sort of scheme to look up a DateGrp variable
and run your table on it.

There may be a more succinct solution out there, but I haven't
found it.  Send me E-Mail if you want more help with this one.

Have fun!
Maria

-- 
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
^   Maria Spicer, DP Specialist		maria@soc.duke.edu           ^
^   140 Soc-Psych Bldg			919-660-5602                 ^
^   Duke University, Durham, NC		919-660-4317                 ^