Does that mean it is working? you will need to drag it down to all rows. I have added in another if for blank dates
=IF(C2="","",IF(C2<2500,TEXT(C2,"@"),IF(DAY(C2)=1, TEXT(C2,"MMM YYYY"),TEXT(C2,"DD mmm yyyy"))))
The formula needs data to work from thats why the extra column, the best option in my opinion is to go with the 3 columns then hide your date column - personally i wouldnt go with the multiple columns across the worksheet but that is just because its not a proper excel table/layout but your call.
The other option would be for VBA to do a simular process on each cell in the date range and over write your data with the new calculated data, but i think that is overkill and also you will lose the data you typed if the calculation or formula was ever wrong.
Hiding seems the easier and most efficent step
|