Apr 02 2023 03:43 PM
I have used the formula (in Dutch) =DATUM(LINKS(A221,4),DEEL(A221,3,2),RECHTS(A221,2)
to change the 8 digit figure that gives the date (20220502) into a regular date.
When I press the function code the window with the function arguments opens. At the bottom this window gives "Result of formula is 02/10/2023. Two problems here: first, the year is obviously wrong but I do not see why this error occurs, Second, the enter function does not concert the formula in the sheet into its formula result.
Who can help ??
Apr 02 2023 04:07 PM
=DATUM(LINKS(A221,4),DEEL(A221,5,2),RECHTS(A221,2))
5 instead of 3.
Right bracket missing at the end.