| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
COnverting Weeks into Month (text data)
In one column, I have all my week data, for example 11/4/2011, 3/2/2012, 5/18/2012, etc for all the weeks that have transpired since Nov 1, 2011.
I want to convert this column into months, so if a week was 11/4/2011, I want it to read Nov; if 3/2/2012, March, and so on and so forth. Is there a formula that can help me? All data (MM/DD/YYYY) is in one single column |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
COnverting Weeks into Month (text data)
hi azabita,
=PROPER(TEXT(A1,"mmmm")) -- isabelle Le 2012-06-08 09:19, azabita a écrit : In one column, I have all my week data, for example 11/4/2011, 3/2/2012, 5/18/2012, etc for all the weeks that have transpired since Nov 1, 2011. I want to convert this column into months, so if a week was 11/4/2011, I want it to read Nov; if 3/2/2012, March, and so on and so forth. Is there a formula that can help me? All data (MM/DD/YYYY) is in one single column |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting Number to Month in Text Problem | Excel Worksheet Functions | |||
| Sum data for weeks in a month | Excel Discussion (Misc queries) | |||
| Converting Month Number to Month Text Abbreviation | Excel Worksheet Functions | |||
| Converting months as # to Text Month | Excel Programming | |||
| Archiving 4 weeks of data into Month folders | Excel Discussion (Misc queries) | |||
Linear Mode
