Month (MMM) from date (dd/mmm/yy)

A

Annie1904

In my spreadsheet I have a date column (col A) which I have in format
(dd/mmm/yy). I need to show the corresponding month in Col B, in MMM format
- April, May, etc.

I'd like the month to appear automatically in the corresponding cell in col
B when I type the date into col A, so that it looks like this:

A B
1 Month Date Added
2 Mar 10 March 2010
3 Apr 04 April 2010
4 May 05 May 2010

I managed to do this in A2 by using the formula =B2 and then changing the
format in cell A2 to MMM. However, I can't successfully copy this formula
down Col A to the other cells! The format is OK. When I try, it simply
copies down the month name, e.g. Mar, to all other cells regardless of which
month is in A3, A4, etc, viz:

A B
1 Month Date Added
2 Mar 10 March 2010
3 Mar 04 April 2010
4 Mar 05 May 2010

What am I doing wrong? Is there a better way to do this?
 
G

Gary''s Student

If your formula does not work, make sure:

Tools > Options > Calculation > Automatic is set.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top