Forum home » Delegate support and help forum » Microsoft Excel Training and help » Dates

Dates

ResolvedVersion 2007

Tue 11 Jan 2011, 17:20 Delegate Alix said...

Alix has attended:
Excel Advanced course

Dates

Hello,

I would like to be able to add a field that shows the name of the month that a date in the previous column relates to. i.e. in column C it says '12/03/2011' and I would like to put a formula in row D that says 'March' - is such a thing possible?

Thank you.

Wed 12 Jan 2011, 15:13 Trainer Anthony said...

RE: Dates

Hi Alix, thanks for your query. This is simpler than you might think. First of all, if C1 says '12/03/2011', then in D1 put "=C1".

Then select C1, r-click Format Cells, choose the Number tab, then Custom and type "mmmm" into the Type: field. That should do the trick!

Hope this helps,

Anthony

Wed 12 Jan 2011, 15:17 Delegate Alix said...

RE: Dates

Thank you ever so much - worked perfectly!

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Adding multiple rows in an Excel 2010 Worksheet

If you want to add more than one row to an Excel Worksheet, drag select the number or rows you want added to the spreadsheet.

Then right click on these selected rows, choose Insert from the menu, and the new rows will be added above the rows you first selected.

View all Excel hints and tips

Dates

Dates

RE: Dates

RE: Dates

Excel articles

Excel tip:

Adding multiple rows in an Excel 2010 Worksheet