User Profile
chrisje1947
Copper Contributor
Joined Apr 02, 2023
User Widgets
Recent Discussions
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 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 ??673Views0likes1Comment
Recent Blog Articles
No content to show