Date formula
 

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?

Date formula
 

"Scott@CW" wrote in message
...
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?

A1 could just contain
=C1
and be formatted as MMM YY

Date formula
 

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?

Date formula
 

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?

Date formula
 

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?

Date formula
 

Try it like this:
=SUMPRODUCT(--(A10:A500=C1),--(TEXT(C10:C500,"mmmyy")=TEXT(C2,"mmmyy")),--(F10:F500=5))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Scott@CW" wrote:
.. 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)