Forum Discussion
excel date formula does not adjust date
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 cod...
=DATUM(LINKS(A221,4),DEEL(A221,5,2),RECHTS(A221,2))
5 instead of 3.
Right bracket missing at the end.