How to look up the long dates and return just the month?

October 4, 2012 at 16:16:58
Specs: Windows XP
I have 50,000 cells with dates from Jan 2011-sept 2012. All i want is to group them by month (Jan 2011, feb 2011...sept 2012). How do i do that?

See More: How to look up the long dates and return just the month?

Report •


#1
October 4, 2012 at 19:24:21
What is the actual format of the Dates?

You could use the MONTH() function, in a new blank column, to return just the Month,
then Sort on the new Month column.

MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question