| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Month
what is the formula for returning the month (eg Aug) of a date?
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Month
=TEXT(A1,"mmm")
"Christine" wrote: what is the formula for returning the month (eg Aug) of a date? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Month
Hi,
you can also use =month(cell_ref) -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Christine" wrote in message ... what is the formula for returning the month (eg Aug) of a date? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Month
need the formula to return 'Aug' and not '8'
"Ashish Mathur" wrote in message ... Hi, you can also use =month(cell_ref) -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Christine" wrote in message ... what is the formula for returning the month (eg Aug) of a date? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Month
Hi
You received the answer to your question by "Teethless mama. Did you try it?? if its not working, tell us what its doing. HTH John "Centrol" wrote in message ... need the formula to return 'Aug' and not '8' "Ashish Mathur" wrote in message ... Hi, you can also use =month(cell_ref) -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Christine" wrote in message ... what is the formula for returning the month (eg Aug) of a date? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Month
Hi,
Try this text(month(cell_ref),"mmmm") -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Centrol" wrote in message ... need the formula to return 'Aug' and not '8' "Ashish Mathur" wrote in message ... Hi, you can also use =month(cell_ref) -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Christine" wrote in message ... what is the formula for returning the month (eg Aug) of a date? |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Month
I'm reluctant to argue with an MVP, Ashish, but I think that your formula
would invariably return January. I think you may have intended to say =text(cell_ref,"mmm") [No MONTH function, and only 3 m characters.] -- David Biddulph Ashish Mathur wrote: Hi, Try this text(month(cell_ref),"mmmm") "Centrol" wrote in message ... need the formula to return 'Aug' and not '8' "Ashish Mathur" wrote in message ... Hi, you can also use =month(cell_ref) -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Christine" wrote in message ... what is the formula for returning the month (eg Aug) of a date? |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Month
Thanks for the correction
-- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... I'm reluctant to argue with an MVP, Ashish, but I think that your formula would invariably return January. I think you may have intended to say =text(cell_ref,"mmm") [No MONTH function, and only 3 m characters.] -- David Biddulph Ashish Mathur wrote: Hi, Try this text(month(cell_ref),"mmmm") "Centrol" wrote in message ... need the formula to return 'Aug' and not '8' "Ashish Mathur" wrote in message ... Hi, you can also use =month(cell_ref) -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Christine" wrote in message ... what is the formula for returning the month (eg Aug) of a date? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel to make the days cary over month to month automaticly | New Users to Excel | |||
| Excel 2003 month to month data change grid | Excel Discussion (Misc queries) | |||
| Subtract a future month from the current month to get remaining m. | Excel Worksheet Functions | |||
| Retrieve data for previous 3, 6, 12 month given current month | Excel Worksheet Functions | |||
| transfer cell $ amount to other sheet month-to-month without overc | Excel Discussion (Misc queries) | |||
![Christine[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
