You are viewing a single comment's thread from:
RE: Not the most productive day in my life! (Fooling around with excel)
Pretty good so far!
Without seeing the file it is difficult to know if I can give any advice. But let me try a simple question. Did you try the function "right" to automatically grab the year from the date column?
Yep, tried it.
The date in the bet tab is manually entered. The format is choosen by the field properties date.
Than this is split up in to 3 fields. For the year (out the top of my head) is tekst(cell;”jjjj”). But this fails when I do open it on the home laptop which is an American version.
Here it does expect “yyyy”.
Did try a lot already. Guess I will have to use my old VBA skills 😔
I think the function =rechts(A5;4) could do the job. Did you try that one?