This seems to do most of what you are looking for. I combined the formula in J2 with a part that making use of the CELL function.
|
A |
B |
C |
D |
E |
F |
G |
H |
I |
J |
K |
L |
1 |
Date Input |
Len |
Text |
Numb |
|
DESIRED RESULT |
|
MY ORIGIONAL FORMULA |
|
YKY FORMULA |
|
FULL SOLUTION ? |
2 |
Jun-79 |
5 |
FALSE |
TRUE |
|
JUNE 1979 |
|
JUNE 1979 |
|
01/06/1979 |
|
June 1979 |
3 |
DEC 1980 - JAN 1982 |
19 |
TRUE |
FALSE |
|
DECEMBER 1980 - JANUARY 1982 |
|
DECEMBER 1980 - JANUARY 1982 |
|
DECEMBER 1980 - JANUARY 1982 |
|
DECEMBER 1980 - JANUARY 1982 |
4 |
FEB 1975 TO APR 1978 |
20 |
TRUE |
FALSE |
|
FEBRUARY 1975 TO APRIL 1978 |
|
FEBRUARY 1975 TO APRIL 1978 |
|
FEBRUARY 1975 TO APRIL 1978 |
|
FEBRUARY 1975 TO APRIL 1978 |
5 |
1980 |
4 |
FALSE |
TRUE |
|
1980 |
|
1980 |
|
1980 |
|
1980 |
6 |
10/03/1988 |
5 |
FALSE |
TRUE |
|
10/03/1988 |
|
MARCH 1988 |
|
10/03/1988 |
|
10/03/1988 |
7 |
10/3/88 |
5 |
FALSE |
TRUE |
|
10/03/1988 |
|
MARCH 1988 |
|
10/03/1988 |
|
10/03/1988 |
8 |
N/A |
3 |
TRUE |
FALSE |
|
N/A |
|
N/A |
|
N/A |
|
N/A |
9 |
NO DATE |
7 |
TRUE |
FALSE |
|
NO DATE |
|
NO DATE |
|
NO DATE |
|
NO DATE |
10 |
|
|
|
|
|
|
|
|
|
|
|
|
Bookmarks