muhammad susanto
Well-known Member
- Joined
- Jan 8, 2013
- Messages
- 2,077
- Office Version
- 365
- 2021
- Platform
- Windows
hi all....
i want to combine 2 formula into 1 formula (Rick's formula)
<tbody>
</tbody>
formula A :
http://www.mrexcel.com/forum/excel-...-number-different-format-date-vs-general.html
then
formula B
http://www.mrexcel.com/forum/excel-questions/880218-extract-some-number-year-2.html
how do make it. It's possible?
thank in advance..
m.susanto
i want to combine 2 formula into 1 formula (Rick's formula)
data (col.a) | result after use formula A | result after use formula B | single formula (combine) ?? |
08/12/2005 (as date) | 2005-12-08 | 2005 | |
01/07/1992 (as date) | 1992-07-01 | 1992 | |
1986-7-45 (as text) | 1986-7-45 | 1986 | |
2001-10-380 (as text) | 2001-10-380 | 2001 |
<tbody>
</tbody>
formula A :
Code:
[COLOR=#333333]=IF(COUNTIF(A1,"*-*"),A1,TEXT(A1,"yyyy-mm-dd"))[/COLOR]
http://www.mrexcel.com/forum/excel-...-number-different-format-date-vs-general.html
then
formula B
Code:
=LEFT(B1,4)+(--LEFT(B1,4)=2010)*(--SUBSTITUTE(MID(B1,5,3),"-","")>6)
http://www.mrexcel.com/forum/excel-questions/880218-extract-some-number-year-2.html
how do make it. It's possible?
thank in advance..
m.susanto