|
|
#6
10-10-2020, 02:13 PM
|
|||
|
|||
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 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Mail merge field mistakenly interpret text format as date format | alan6690 | Mail Merge | 0 | 09-02-2020 01:54 AM |
| Create Field That Displays Date+30, Office 2007 | Papote | Word | 6 | 10-09-2016 02:47 PM |
 Date format but with Jan Feb mar etc how is this done ?
|
DBenz | Excel | 3 | 12-21-2014 05:00 AM |
| Letter date changes when merging with Excel - not the format, the actual date! | Smallweed | Mail Merge | 1 | 02-07-2014 06:00 PM |
| date format | gsrikanth | Excel | 1 | 12-28-2011 05:06 AM |
Windows 10 
Office 2019
Threaded Mode