| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I list dates without years?
I'm creating a list of birthdays that cannot contain the birth year. Since
there will be additions and deletions over time, I'd like to just have the month and day in the column. Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I list dates without years?
Simply format column A as Custom mmmm dd
OR................. Enter the birthdays in column A in regular m/d/y format. In an adjacent column enter =TEXT(A1,"mmmm dd") Copy and paste specialvalues in place Note: will sort alphabetically by month Gord Dibben MS Excel MVP On Mon, 15 Mar 2010 16:53:02 -0700, Osborne wrote: I'm creating a list of birthdays that cannot contain the birth year. Since there will be additions and deletions over time, I'd like to just have the month and day in the column. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Add/Sum up months, years, dates | Excel Worksheet Functions | |||
| change a list of 2 digit years to 4 digit years? | Excel Worksheet Functions | |||
| Dates = years old | Excel Discussion (Misc queries) | |||
| How do I subtract dates to get a number in years or years & month | Excel Discussion (Misc queries) | |||
| How do get the years and days Between two dates | Excel Discussion (Misc queries) | |||
Hybrid Mode
