I have data I've exported that is in format mm/dd/yyyy. I'm trying to
pivot to count the number of records per mmm-yyyy. Is there a way to
change or convert the data of the date--not just the format--to dd-mmm-
yyyy such that I can then add a formula to pull the middle and end
(using MID function) to just give me the mmm-yyyy for my pivot? Or an
esier way if anyone knows that achieves the same endpoint would be
greatly appreciated.