Need help converting a date to a sortable #

V

VH5150

Board Regular
Joined
Mar 1, 2004
Messages
60
I have a column of cells with a date formatting like Jun-04. I would like to place a column beside it that has the serial date so I can sort the column in chronological order. Any ideas? Thanks,

Eddie
 

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.
Norie

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,343
Office Version
  1. 365
Platform
  1. Windows
Eddie

Are these actually dates, just formatted for month/year?

If they are then you shouldn't need to change them to sort them.
 
V

VH5150

Board Regular
Joined
Mar 1, 2004
Messages
60
Good Point

This works! Maybe I'm retarded. Sorry to waste your time.
 
You must log in or register to reply here.

Similar threads

A
  • Question
Merging across excel workbooks for Mac
Replies
1
Views
86
Jim Gordon Mac MVP
J
C
  • Question
VBA Code To Sort and Autofilter Specific Date Column with Header
Replies
3
Views
139
Micron
M
redspanna
  • Solved
Sorting dates as text using UNIQUE formula
Replies
4
Views
210
Peter_SSs
Peter_SSs
T
  • Question
Dynamic Schedule Of Dates
Replies
0
Views
140
TheKitchenMan
T
Q
  • Solved
date Subtraction with serial numbers as a reference
Replies
7
Views
235
Fluff
Fluff
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,802
Messages
5,833,755
Members
430,230
Latest member
Doug G

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top