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 |
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 | |
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 |
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 || | | |
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 |
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. |
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 --- |
All times are GMT +1. The time now is 07:57 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com