All,

when I try to reformat dates that are in a yyyymm format (200510) into a
mmm-yyyy format (Oct 2005) the conversion doesn't come close and I end up
with dates from the year 2048 amongst others. Any thoughts on how to fix
this? I am trying to apply it to a formula that will allow me to sum the
follwing:

=SUM((RawData!$CT$2:$CT$2000=$B3)*(RawData!$A$2:$A $2000=$C3)*(RawData!$AL$2:$AL$20000)*(RawData!$AL $2:$AL$2000<7))

where I can use a Oct of 2005 and a < May of 2006 to track how many people
have completed a test in that time frame... but it's not working for me. The
0 and <7 are being used to count how many months old the test is but I need
to start from the beginning of the Fiscal Year.

THanks.

If a cell has an entry like "200510" you could put this formula in a cell to
get the date 1 Oct 2005:

=DATE(LEFT(A1,4),RIGHT(A1,2),1)

--
Jim
"zeke2230" wrote in message
...
| All,
|
| when I try to reformat dates that are in a yyyymm format (200510) into a
| mmm-yyyy format (Oct 2005) the conversion doesn't come close and I end up
| with dates from the year 2048 amongst others. Any thoughts on how to fix
| this? I am trying to apply it to a formula that will allow me to sum the
| follwing:
|
|
=SUM((RawData!$CT$2:$CT$2000=$B3)*(RawData!$A$2:$A $2000=$C3)*(RawData!$AL$2:$AL$20000)*(RawData!$AL $2:$AL$2000<7))
|
| where I can use a Oct of 2005 and a < May of 2006 to track how many
people
| have completed a test in that time frame... but it's not working for me.
The
| 0 and <7 are being used to count how many months old the test is but I
need
| to start from the beginning of the Fiscal Year.
|
| THanks.