Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I extract a month from Excel date?
I have a cell, U9 showing the date, custom formatted as dd-mmm-yy. e.g.
31-Oct-06 I need another cell to show just the month. e.g. Oct The formula =MID(U9,4,3) always returns a 2 digit number regardless of what date is in U9. I assume it is the Excel date value that the MID formula is taking the final two digits from. How do I get it to show the month as text. e.g. Oct Thanks, Lee |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I extract a month from Excel date?
Hi Lee,
=U9, Format Custom as ddd -- Kind regards, Niek Otten Microsoft MVP - Excel "Lee" wrote in message ... |I have a cell, U9 showing the date, custom formatted as dd-mmm-yy. e.g. | 31-Oct-06 | I need another cell to show just the month. e.g. Oct | The formula =MID(U9,4,3) always returns a 2 digit number regardless of what | date is in U9. I assume it is the Excel date value that the MID formula is | taking the final two digits from. | How do I get it to show the month as text. e.g. Oct | | Thanks, | Lee | |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I extract a month from Excel date?
Try: =TEXT(U9,"mmm")
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Lee" wrote: I have a cell, U9 showing the date, custom formatted as dd-mmm-yy. e.g. 31-Oct-06 I need another cell to show just the month. e.g. Oct The formula =MID(U9,4,3) always returns a 2 digit number regardless of what date is in U9. I assume it is the Excel date value that the MID formula is taking the final two digits from. How do I get it to show the month as text. e.g. Oct Thanks, Lee |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I extract a month from Excel date?
<ddd
make that mmm -- Kind regards, Niek Otten Microsoft MVP - Excel "Niek Otten" wrote in message ... | Hi Lee, | | =U9, Format Custom as ddd | | -- | Kind regards, | | Niek Otten | Microsoft MVP - Excel | | "Lee" wrote in message ... ||I have a cell, U9 showing the date, custom formatted as dd-mmm-yy. e.g. || 31-Oct-06 || I need another cell to show just the month. e.g. Oct || The formula =MID(U9,4,3) always returns a 2 digit number regardless of what || date is in U9. I assume it is the Excel date value that the MID formula is || taking the final two digits from. || How do I get it to show the month as text. e.g. Oct || || Thanks, || Lee || | | |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I extract a month from Excel date?
Thanks for both suggestions. Both do the job.
"Lee" wrote: I have a cell, U9 showing the date, custom formatted as dd-mmm-yy. e.g. 31-Oct-06 I need another cell to show just the month. e.g. Oct The formula =MID(U9,4,3) always returns a 2 digit number regardless of what date is in U9. I assume it is the Excel date value that the MID formula is taking the final two digits from. How do I get it to show the month as text. e.g. Oct Thanks, Lee |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I extract a month from Excel date?
You're welcome, Lee !
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Lee" wrote in message ... Thanks for both suggestions. Both do the job. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I extract a month from Excel date?
.. Both do the job.
In terms of showing / display in the formula cell, yes. But there's a subtle difference in the underlying values. Formatting retains it as a number, while using TEXT converts it to text. The underlying value would of course impact any downstream formulas pointing to that formula cell. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date arithmetic: adding 1 month to prior end of month date | Excel Worksheet Functions | |||
excel array formula | Excel Worksheet Functions | |||
date format in excel not in line with control panel regional setti | Excel Discussion (Misc queries) | |||
Excel date field link to Word | Excel Discussion (Misc queries) | |||
Excel: Is there a way to calculate the date as week of month? | Excel Discussion (Misc queries) |