Date formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Scott@CW said:
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?
Click to expand...

A1 could just contain
=C1
and be formatted as MMM YY
 
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)
 
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")
 
Try it like this:
=SUMPRODUCT(--(A10:A500=C1),--(TEXT(C10:C500,"mmmyy")=TEXT(C2,"mmmyy")),--(F10:F500=5))
 
Back
Top