| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
changin date dd/mm/yy into Month
I am trying to summarise dates from 01/04/09 to April. Can any body help.
I have tried = month(cell) , but it comes up with a value . Any ideas? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
changin date dd/mm/yy into Month
Input date as you have.
Format cells Custom format mmmm -- Russell Dawson Excel Student Please hit "Yes" if this post was helpful. "Jo" wrote: I am trying to summarise dates from 01/04/09 to April. Can any body help. I have tried = month(cell) , but it comes up with a value . Any ideas? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
changin date dd/mm/yy into Month
If you have a date in say, A1, and you want to show the month in B1, in B1
enter "=A1" without the quotes. Now format B1 as custom mmmm. HTH Otto "Jo" wrote in message ... I am trying to summarise dates from 01/04/09 to April. Can any body help. I have tried = month(cell) , but it comes up with a value . Any ideas? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
changin date dd/mm/yy into Month
Might be your date is not a date, but text.
What happens when you try to format it? Gord Dibben MS Excel MVP On Fri, 5 Mar 2010 06:28:01 -0800, Jo wrote: I am trying to summarise dates from 01/04/09 to April. Can any body help. I have tried = month(cell) , but it comes up with a value . Any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count month when date is in day/month/year format | Excel Worksheet Functions | |||
| Match Month in Date With Month in Header | Excel Worksheet Functions | |||
| Date arithmetic: adding 1 month to prior end of month date | Excel Worksheet Functions | |||
| Sort month/date/year data using month and date only | Excel Discussion (Misc queries) | |||
| =VLOOKUP(1,Nationality!B5:B29,IF(MONTH(date)6,MONTH(date)-6, MON | Excel Worksheet Functions | |||
Linear Mode
