Sorting dates by month instead of year
I rec'd a "value" error!
"~L" wrote:
If the birthday date is in column B:
=text(B2,mm/dd)
Will produce results that will sort by month.
"MMangen" wrote:
I am trying to sort my employee birthday list by month and then date so I can
see at a glance upcoming birthdays. However, no matter what I do I seem to be
getting the results sorted by the year, which I do not want.
|