G Guest Oct 17, 2006 #1 I want to list our Departments birthdates. By month, date and year would be there but I don't want it sorted by year.
I want to list our Departments birthdates. By month, date and year would be there but I don't want it sorted by year.
G Guest Oct 17, 2006 #2 Hi, in an auxiliar column use =month(a2)&day(a2)&year(a2) copy it donw and sort using this column hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Shebamandy" escreveu:
Hi, in an auxiliar column use =month(a2)&day(a2)&year(a2) copy it donw and sort using this column hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Shebamandy" escreveu:
B Bob Phillips Oct 17, 2006 #3 Use =TEXT(MONTH(A2),"00")&TEXT(DAY(A2),"00")&YEAR(A2) otherwise it will sort incorrectly -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct)
Use =TEXT(MONTH(A2),"00")&TEXT(DAY(A2),"00")&YEAR(A2) otherwise it will sort incorrectly -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct)
