Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change full date to month only
Hello,
What formula can I use to pull out the month only on a date formatted as follows: 3/28/2009 I know I can re-format the cell but I am interested in help with a formula Thanks Jim |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change full date to month only
=Month(A1)
If this post helps click Yes --------------- Jacob Skaria "Jim" wrote: Hello, What formula can I use to pull out the month only on a date formatted as follows: 3/28/2009 I know I can re-format the cell but I am interested in help with a formula Thanks Jim |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change full date to month only
You can also use....and adjust the format to your need.
=CHOOSE(MONTH(A1),"JAN","FEB","mar","apr","may",.. ..........,"DEC") If this post helps click Yes --------------- Jacob Skaria "Jim" wrote: Hello, What formula can I use to pull out the month only on a date formatted as follows: 3/28/2009 I know I can re-format the cell but I am interested in help with a formula Thanks Jim |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change full date to month only
try this
if you want the month to appear as numeric =MONTH(A2) or Mar in your example =TEXT(A8,"mmm") -- Hope this is helpful Pls click the Yes button below if this post provide answer you have asked Thank You cheers, francis Am not a greek but an ordinary user trying to assist another "Jim" wrote: Hello, What formula can I use to pull out the month only on a date formatted as follows: 3/28/2009 I know I can re-format the cell but I am interested in help with a formula Thanks Jim |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Calc a full month | Excel Worksheet Functions | |||
Autofilter by month & year when I have a column full of dates ?? | Excel Discussion (Misc queries) | |||
how to calculate a month without the full date? | New Users to Excel | |||
how to change date formating-grouped by month in pivot table | Excel Discussion (Misc queries) | |||
How to manage/change the default month/day date format? | Excel Discussion (Misc queries) |