Prev: SUMPRODUCT Returning 0 or wrong totals
Next: Parsing Information from a Cell
From: Jo on 5 Mar 2010 09:28
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?
From: Russell Dawson on 5 Mar 2010 10:12
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?
From: Otto Moehrbach on 5 Mar 2010 10:15
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" <Jo(a)discussions.microsoft.com> wrote in message
news:3C1B7EC1-71C9-4B27-ACB2-DFFFDB755DDD(a)microsoft.com...
> 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?

From: Gord Dibben on 5 Mar 2010 17:00
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 <Jo(a)discussions.microsoft.com> 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?

 | 
Pages: 1
Prev: SUMPRODUCT Returning 0 or wrong totals
Next: Parsing Information from a Cell