Sorry I know this is lame.
I have a column showing dates like so:
10/19/2013.
I want to add a column next to it to display this as October 2013.
Anyone can help?
Thanks so much
Sorry I know this is lame.
I have a column showing dates like so:
10/19/2013.
I want to add a column next to it to display this as October 2013.
Anyone can help?
Thanks so much
Assume your data on A2, place this code on B2
Note: make sure your data on date formatPlease Login or Register to view this content.
Click (*) if you received helpful response.
Regards,
David
THANKS!
Also - do you know how I can make all dates on a column be the same:
8/31/2013
8.6.13
So they are presented the same way instead of one with / and other with .
One question: the format of your data are fix? Event with "/", "." or "-"?
I mean: month/day/year, month.day.year or month-day-year ?
Idk ):
here is the column - notice for example 616 and others:
Unifying DATE format - notice 616.xlsx
The reason I am asking is that I would like to add a FILTER, and so I need the entire column to be unified.
Turning all DATES to the same format. Let's say, they all will look like this:
10/20/2013
I see your data, the different format only use "." and I assume all format month.day.year
so use this:
by the way, for the year, because it's only 2 digit, I assume it's as >=2000Please Login or Register to view this content.
I forgot, if the column already format as date, you don't need use this formula:
instead use format cellPlease Login or Register to view this content.
1. go to home, format, format cell... or right click the cell and choose format cell...
2. in tab number, choose custom, and on field "type:" type "mmmm yyyy" (without quote "")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks