Ecel Dumbo
Member
Hi, I have a column where dates appear as (28/02/2015 12:00:00 AM) when i download data from source. I would like to create another column which shows the date as (Feb-2015) and another column with preceding date , say in this case , it'll be (Jan-2015)
I can change these dates to the desired format by "change format" but when I use a pivot table on columns with Feb-2015, Mar-2015 etc, the date in the pivot table drop down menu still apears as (28/02/2015 12:00:00 AM) or in repeated formats of Feb-2015, instead of combining all similar dates to one month
How can I fix that ? Thanks
I can change these dates to the desired format by "change format" but when I use a pivot table on columns with Feb-2015, Mar-2015 etc, the date in the pivot table drop down menu still apears as (28/02/2015 12:00:00 AM) or in repeated formats of Feb-2015, instead of combining all similar dates to one month
How can I fix that ? Thanks