View Single Post
 
Old 10-10-2020, 02:13 PM
Purfleet Purfleet is offline Windows 10 Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

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
Reply With Quote