| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I sort a birthdate list by month then day regardless of ye.
I created a spreadsheet with customer data which includes their birthdate.
How should it be entered so that I can sort it according to month then day regardless of year? I just want to see a list of birthdays coming up. |
|
#2
|
|||
|
|||
|
Hi ejeff
You can use helper columns =month(a1) =day(a1) and sort on this columns -- Regards Ron de Bruin http://www.rondebruin.nl "ejeff" wrote in message ... I created a spreadsheet with customer data which includes their birthdate. How should it be entered so that I can sort it according to month then day regardless of year? I just want to see a list of birthdays coming up. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Address List in Excel | Excel Discussion (Misc queries) | |||
| Data > Sort function amnesia? | Excel Discussion (Misc queries) | |||
| Pivot Table - Group by Month - Show Items with no data | Excel Discussion (Misc queries) | |||
| Counting Repeated text or duplicates in a list | Excel Discussion (Misc queries) | |||
| How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) | |||
Linear Mode
