i have a date range in J that shows "1/9/2022 - 1/15/2022" which i need to convert to show the name of the month for the first date only. I was using =text(left(J2,10),"mmmm") before my file was corrupted. now im starting over and putting all formulas in from scratch. this one was working but isnt anymore. Any ideas why not and how to fix it?