On 2002-02-18 14:08, J Lowe wrote:
Ok guys....I'm really starting to feel dumb here. For some reason, my results are not turning out the way I need them to.
This is a part of the data set that I am working with:
Matter Period
1191
1091
1091
0150
This is Juan's formula as I have entered it:
=DATE(RIGHT(G2,2)+((RIGHT(G2,2)<"29")*2000),LEFT(G2,2),1)
These are the results I am getting for the same set:
1/0/1900
I am needing:
Matter Period
11/91
10/91
10/91
01/50
Or:
Matter Period
11/1991
10/1991
10/1991
01/1950
The reason I am needing it in this format is that I am working with Pivot Tables and the sort is not working properly, due to the format of the dates. My goal is to have these numbers in a format where I can sort my data by the date of the matter.
This is how my Pivot Table is set up:
Matter
Date Owner Aty Total
0100 COAT BARRY $5,890.00
JAMES $13,919.50
0101 COAT JAMES $37,093.12
0102 COAT BARRY $6,613.50
JAMES $71,849.50
As you can see, it is sorting my data by the first numbers, or the month, and not the year. I have to have it sorted by year and month.
Any more recommendations?
I appreciate your help.
Jason