Hello!
I have a list of employees and their birthdates. The birthdates are imported in date format. I need to have them in text format so that I can list them by calendar month.
Is there a way to do this?
Hello!
I have a list of employees and their birthdates. The birthdates are imported in date format. I need to have them in text format so that I can list them by calendar month.
Is there a way to do this?
Can you show a few examples of what you have and what you want?
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
If they are Excel dates, then
=text(a1, "MMMM")
Here is an example:
March 6, 2004
September 22, 1962
January 15, 1996
December 20, 2000
I import this into Excel from our payroll database.
The dates are imported in date format.
I need to generate a birhtday list, by month and day. The year is not important. This is what I need to see:
Jan 15
March 6
Sept 22
Dec 20
When I sort the column with the dates, it sorts by year, month, day.
When I convert it to text, it sorts it alphabetically.
Any help would be appreciated.
Try:
=TEXT(A1,"mmm d") were A1 house first date.
then sort by this column.
Did it and it sorted alphabetically...so Dec was the first item (because it is now text???)
I must be missing something here!
It worked fine for me...putting Jan at top and Dec at bottom....
Make sure your "sort by" category is that new column and that when it asks if you want to sort what looks like numbers as numbers, you say Ok.
also, try this...
after initiating the Sort window click Options, then in the " first key sort order" drop down select the one with months (e.g. Jan, Feb, Mar...). Then click Ok.
If you want to sort my date irrespective of year, then add this formula and sort by the column that contains it:
=DATE(0, MONTH(A1), DAY(A1))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks