| Home |
| Search |
| Today's Posts |
|
#4
|
|||
|
|||
Or: =TEXT(B2,"mm-dd")
Myrna Larson wrote: Or, if you want to sort by month and DAY, make the formula =MONTH(B2)*100+DAY(B2) On Mon, 26 Sep 2005 09:01:18 +0100, "Bob Phillips" wrote: In a helper column, add a formula of =MONTH(B2) copy down, and sort by the helper column. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Showing data per month & year for comparison | Excel Discussion (Misc queries) | |||
| sort dates by day then month, not by year. | Excel Worksheet Functions | |||
| HELP - need to returns the current number of past month this year and ... | Excel Worksheet Functions | |||
| Month Year Date Format | Excel Worksheet Functions | |||
| How to sort by day and month while ignoring year? | Excel Worksheet Functions | |||
Threaded Mode
