Sorting Dates by Month and Day only
Glad I could help
"John P" wrote:
Thanks Mike. Your solution works
"Mike H" wrote:
Hi,
You need a helper column. Say your data are in A1 down put the formula below
in b1 and fill down and sort both columns on this newly created column
=TEXT(A1,"mmdd")
Mike
"John P" wrote:
I have a column of dates in mm/dd/yyyy format. How can I sort them according
to month and day only. Can I use the Sort/Filter function or do I have to
create formulas to do it? Thanks for your help.
|