This content has been marked as final. Show 5 replies
I have a date column and I have converted into month-year by doing
=Month(date) & '-' & (Year(date) )
now I have two questions:
1. I am getting a date as - as one of value
2. how to sort date in month-year.
I tried doing that by going to sorting --> expression -->Month(date) & '-' & (Year(date) ) but it didn't sort it out