Formula between 2 pcs

[handri]

I have 2 PC with same workbook and formula.

PC A WORKS

TSB BARCODE 2023.xlsx
	I	J	K
5	DATE CODE	DATE CONVERTED	EXP.DATE
6	L22112402610	24-11-2022	24-5-2023
PWB Data Scanner 2023

Cell Formulas
Range	Formula
J6	J6	=IF(LEN(I6)=12,DATEVALUE(TEXTJOIN("/",,(MID(I6,{6,4,2},2)))),DATE(MID(I6,3,4),MID(I6,7,2),RIGHT(I6,2)))
K6	K6	=EDATE(J6,6)
Press CTRL+SHIFT+ENTER to enter array formulas.

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
J4:K5	Cell Value	contains "NOT IN DATABASE"	text	NO
J4:K5	Cell Value	contains "NOT IN DATABASE"	text	NO
K2,G1,I3:K3,I1:K1,I4:I5,M6:M2695,I6:K1048576,G3:G1048576,H6:H2695	Cell Value	contains "NOT IN DATABASE"	text	NO
K2,G1,I3:K3,I1:K1,I4:I5,M6:M2695,I6:K1048576,G3:G1048576,H6:H2695	Cell Value	contains "NOT IN DATABASE"	text	NO

PC B NOT WORKS

No idea what going on here. Actually is the same file and formula but opening in PC B is not working

thanks

 

[kevin9999]

Possibly an earlier version of Excel on PC B? Textjoin is a relatively newer function, and the #Name error usually means that the function can't be found on that PC'S version of Excel.

 

[handri]

Possibly an earlier version of Excel on PC B? Textjoin is a relatively newer function, and the #Name error usually means that the function can't be found on that PC'S version of Excel.

PC B is Microsoft Office 365. Possible to converting to suggestion types of excel?

thanks

 

[kevin9999]

365 is the latest version and should recognise all the functions used in post #1.

 

[handri]

365 is the latest version and should recognise all the functions used in post #1.

Its missing the =TEXTJOIN function formula.

Mine office 365. Any way to enable this?

thanks

 

[kevin9999]

It should be available in 365 - see here: TEXTJOIN function - Microsoft Support although you may need to update your 365 version to get the latest function releases.

 

[Peter_SSs]

Try

=IF(LEN(I6)=12,DATE(2000+MID(I6,2,4),MID(I6,4,2),MID(I6,6,2)),DATE(MID(I6,3,4),MID(I6,7,2),RIGHT(I6,2)))

 

[handri]

Try

=IF(LEN(I6)=12,DATE(2000+MID(I6,2,4),MID(I6,4,2),MID(I6,6,2)),DATE(MID(I6,3,4),MID(I6,7,2),RIGHT(I6,2)))

Hi Pete

thanks for your help, its work

TSB BARCODE 2023.xlsx
	I	J	K
5	DATE CODE	DATE CONVERTED	EXP.DATE
6	L22112402610	24-11-2022	24-5-2023
7	L22112402615	24-11-2022	24-5-2023
PWB Data Scanner 2023

Cell Formulas
Range	Formula
J6:J7	J6	=IF(LEN(I6)=12,DATE(2000+MID(I6,2,2),MID(I6,4,2),MID(I6,6,2)),DATE(MID(I6,3,4),MID(I6,7,2),RIGHT(I6,2)))
K6:K7	K6	=EDATE(J6,6)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
J4:K5	Cell Value	contains "NOT IN DATABASE"	text	NO
J4:K5	Cell Value	contains "NOT IN DATABASE"	text	NO
K2,G1,I3:K3,I1:K1,I4:I5,M6:M2695,G3:G1048576,H6:H2695,I6:K1048576	Cell Value	contains "NOT IN DATABASE"	text	NO
K2,G1,I3:K3,I1:K1,I4:I5,M6:M2695,G3:G1048576,H6:H2695,I6:K1048576	Cell Value	contains "NOT IN DATABASE"	text	NO

 

[Peter_SSs]

Hi Pete

thanks for your help, its work

You're welcome. Thanks for the confirmation.