Quick Links ▼

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » introduction excel training - Date Sorting

	98.1 % recommend us
	More live stats...

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

Training information:

introduction excel training - Date Sorting

Resolved · Low Priority · Version Standard

Reply Wed 19 Sep 2007, 10:38Delegate Norah said...

Norah has attended:
Powerpoint Introduction course

Date Sorting

Hi,

Is is possible to have a date column just reading the month, and sorting as the month, rather than in alphabetical.

I understand that you can have date in a number of standard options (eg 01/01/07 , 01 January 07 etc) but is there a way where you simply just view the month in text (eg January , March), but it recognises it as a date rather than text.

Many thanks,
Norah.

For upcoming training course dates see: Pricing & availability

Reply Tue 25 Sep 2007, 15:40Trainer Anthony said...

RE: Date Sorting

Hi Norah. Yes, this is possible - in Excel. Use the Sort dialog box as usual but click on Options at the bottom left hand corner and make sure your "First Key Options" are set to the months of the year. This then becomes the default sort order.

Hope this helps,

Anthony

Reply Wed 26 Sep 2007, 09:57Delegate Norah said...

RE: Date Sorting

Hi Anthony,

Thank you very much. I'm finding this and all the other responses very helpful.

Norah.

Excel articles

· Conditional Formatting: A Useful Feature Of Excel
· Using The Drawing Toolbar In Excel
· How To Manage Your Everyday Spending In Excel
· Excel Charts As Easy As Pie
· How To Create An Argument With Excel

Excel tip:

Creating a range of monthly payments as text

You could use a formula to create a range of payment ie. payment amount for x% to y% rate with fixed terms and principle.

The text that would be "between Xamount and Yamount".

Here is how to do it.

1 Use the PMT function to get your monthly payments figure or whatever frequency of payments that you choose he start range.

See PMT under Excel Help

2. Nest these in the ROUND function to round decimals see ROUND under Excel Help

3. Concatenate this using "&" and concatenate " to " and concatenate "Between ".

4. Concatenate the above to PMT function for the end range

ie.

="Between "&ROUND((PMT1),decimal places)&" and "&ROUND((PMT2),decimal places)

View all Excel hints and tips