| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I want to sort by month, date, year. Birthdates. How do I do it
I want to list our Departments birthdates. By month, date and year would be
there but I don't want it sorted by year. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I want to sort by month, date, year. Birthdates. How do I do it
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: I want to list our Departments birthdates. By month, date and year would be there but I don't want it sorted by year. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I want to sort by month, date, year. Birthdates. How do I do it
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) "Marcelo" wrote in message ... 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: I want to list our Departments birthdates. By month, date and year would be there but I don't want it sorted by year. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Mileage Claim Formula | New Users to Excel | |||
| how to insert month date year and day of week | Excel Discussion (Misc queries) | |||
| how to insert month date year and day of week | New Users to Excel | |||
| counting date entries by month & year | Excel Worksheet Functions | |||
| create a date from year, day and month | Excel Worksheet Functions | |||
Linear Mode
