Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Dates

Resolved · Low Priority · Version 2007

Reply Tue 11 Jan 2011, 17:20Delegate 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.

For upcoming training course dates see: Pricing & availability

Reply Wed 12 Jan 2011, 15:13Trainer 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

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

RE: Dates

Thank you ever so much - worked perfectly!

Excel articles

· How To Protect Your Work In Excel 2010
· Excel Course Tips and Tricks to Liven Up Your Excel Spreadsheets
· 3 Ways that MS Excel Courses Can Drastically Improve Productivity for Teachers
· Which Is Better, Excel Or Access?
· Do You Need To Upgrade From Excel 2003 to Excel 2007?

Please browse our web site to find out more about
excel classes and other Microsoft training courses.

Excel tip:

Use Paint Brush to Format More than one Cell

To copy a format to many cells or ranges

1. Select the cell with the format that you want to copy

2. Double-click on the paint brush

When you move to the cell where you want to paste the format you will notice that a paint brush follows the cursor.

Paste the format to all the cells or ranges you need to format.

When finished go back to the paint brush on the tool bar and single click on it to deactivate the function.

View all Excel hints and tips