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.