I have a field that contains a time period. ie: 01/01/2017-01/07/2017 I only need the first date
I'm using =left(xx,find("-",xx)-1) which works fine. I get 01/01/2017
I need that ending value to be formatted like Jan 2017. I created a NEW column for month/year. =text(xx,"mmm yyy")
is there anyway to do this all in one step?
thank you
Steve B
Bookmarks