It sounds like your 'dates' (e.g. C2, C10:C500) are not dates at all, but
text strings (e.g. "Aug-07").
So instead of the formula =C1 and formatting of mmm-yy you could try the
formula
=TEXT(C1,"mmm-yy")

"Scott@CW" wrote in message
...
That worked great for the format problem, but I have created another
problem. I am using a sumproduct formula, and it is not recognizing the
date.
Below is the formula I am using.

=sumproduct(--(A10:A500=c1),--(C10:C500=c2),--(F10:F500=5))

C1= name from A DV list
C2= dates from a DV list (dates in list are same format as orginal
question
ex. Aug-07)

"Mike H" wrote:

Try

=C1 in A1 and drag down as required then apply a custom format of
mmmyy

Mike

"Scott@CW" wrote:

In column C I have a list of dates (8/16/2007), I want to right a
formula in
column A that would return just the month and year (OCT07). Is this
possible?