Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() One solution would be to create a column next to the list of dates which just shows the month number. IE: If your list was in column A, then the formula in column B for each cell would be: =MONTH(A1) etc, so if you had 10 dates in column A, then you would have 10 of the above formulas in column B. You could then perform a sort on the range A1:B10 using column B as the sort key. This column can always be hidden if necessary. -- Cumberland ------------------------------------------------------------------------ Cumberland's Profile: http://www.excelforum.com/member.php...o&userid=33445 View this thread: http://www.excelforum.com/showthread...hreadid=534157 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Counting dates, within a list of dates | Excel Worksheet Functions | |||
update cells to today date in a list of dates | Excel Worksheet Functions | |||
update cells to today date in a list of dates | Excel Worksheet Functions | |||
list formula for dates | Excel Worksheet Functions | |||
Total number of each month in a column of dates | Excel Worksheet Functions |