Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create a formula in a date range to locate a specific date - ecel | Excel Discussion (Misc queries) | |||
Excel Formula to calulate number of days passed from date to date | Excel Discussion (Misc queries) | |||
Formula for determining if two date columns fall within specific date range | Excel Worksheet Functions | |||
Formula for determining if two date columns fall within specific date range | Excel Discussion (Misc queries) | |||
formula to calculate future date from date in cell plus days | Excel Worksheet Functions |