excel date formula does not adjust date

Copper Contributor

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 ??

1 Reply




5 instead of 3.

Right bracket missing at the end.