Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Returning the month (mmm) from cell in date format dd/mm/yyyy
HI In C3 I have date in the form dd/mm/yyyy. I'm trying to return this in A3 as mmm. EG 12/04/2010 in C3 would return upper APR in A3 Can someone help with this? Grateful for any advice. BTW I'd then need to incorporate the code into an existing formula in A3 : =IF(C3="","",UPPER(LEFT(M$3,3)&TEXT(ROW()-3,"000")&-'Purchase Record'!$A$1)) where the date coding would replace the M$3 part so if someone can also help with this too I'd be double grateful. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Returning the month (mmm) from cell in date format dd/mm/yyyy
On Sun, 5 Feb 2012 01:09:40 +0000, Colin Hayes wrote:
HI In C3 I have date in the form dd/mm/yyyy. I'm trying to return this in A3 as mmm. EG 12/04/2010 in C3 would return upper APR in A3 Can someone help with this? Grateful for any advice. BTW I'd then need to incorporate the code into an existing formula in A3 : =IF(C3="","",UPPER(LEFT(M$3,3)&TEXT(ROW()-3,"000")&-'Purchase Record'!$A$1)) where the date coding would replace the M$3 part so if someone can also help with this too I'd be double grateful. Assuming that the entry is a normal Excel date, and not a text string, then: =UPPER(TEXT(C3,"mmm")) would return APR |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Returning the month (mmm) from cell in date format dd/mm/yyyy
In article , Ron Rosenfeld
writes Assuming that the entry is a normal Excel date, and not a text string, then: =UPPER(TEXT(C3,"mmm")) would return APR HI OK Thanks for your help. This works perfectly first time. ^_^ Best Wishes |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Returning the month (mmm) from cell in date format dd/mm/yyyy
On Sun, 5 Feb 2012 02:07:55 +0000, Colin Hayes wrote:
In article , Ron Rosenfeld writes Assuming that the entry is a normal Excel date, and not a text string, then: =UPPER(TEXT(C3,"mmm")) would return APR HI OK Thanks for your help. This works perfectly first time. Glad to help. Thanks for the feedback. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change date format from dd/mm/yyyy to mm/yyyy | Excel Discussion (Misc queries) | |||
How to show only Month of a mm/dd/yyyy format? | Excel Discussion (Misc queries) | |||
Converting Day, Date Month Year format to MM/DD/YYYY | Excel Worksheet Functions | |||
how do I change date from mm/dd/yyyy to dd:mm:yyyy format in Excel | New Users to Excel | |||
opening excel file - date format problem: DD/MM/YYYY vs MM/DD/YYYY | Excel Programming |