|
|
#12
03-15-2022, 01:59 AM
|
||||
|
||||
Quote:
Easy to cope with. Supposing there are no years before 1941, say, just check if the "year" in the data ( 1965, say) is smaller than 15000 ( somewhere in 1941), the build a fake date with the DATE function Code:
=IF(B2>15000;YEAR(B2);YEAR(DATE(B2;1;1)))
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Formula For Sorting In Order Date Wise
|
suniltko | Excel | 5 | 05-15-2018 09:18 PM |
| Sorting Problem | RonLEngle | Excel Programming | 8 | 12-19-2017 01:15 PM |
| Sorting problem in Excel | nrsmd | Excel | 2 | 10-08-2017 11:54 AM |
|
Problem sorting names alphabetically?
|
mikehende | Excel | 12 | 09-12-2012 12:00 PM |
| sorting problem | gsrikanth | Excel | 4 | 02-16-2012 12:30 AM |
Windows 7 64bit 
Office 2010
Threaded Mode