Sorting Month Only
Put the below formula & copy the same till u need.
=TEXT(A1,"mm/dd")
01/01/02 = "01/01"
the above formula will provide u as "01/01", if u need the result as
JAN/01, then use "mmm/dd", for January/01 then use "mmmm/dd"
Hope the above solution will help u.
----
Selvarathinam.
|