In a report, dates should be presented in month/year format.

Instead of 23.2.2020 the report should show 2/2020.

Just use MONTH and YEAR functions.

We get same results also with string function MID, SEARCH and RIGHT.

The sentence is here for copy pasting.

=MID(B2;SEARCH(“.”;B2)+1;SEARCH(“.”;B2;SEARCH(“.”;B2)+1)-SEARCH(“.”;B2)-1) & “/” & RIGHT(B2;LEN(B2)-SEARCH(“.”;B2;SEARCH(“.”;B2)+1))

First, we have a MID function which extracts number of digits from the middle of the string. The MID includes three arguments: where the extract is done, where the extraction starts and how many digits are to be extracted.

We are extracting the digits inside the cell B2, we start extracting the digits starting from the digit after the first dot. When the value is 23.2.2020, the extract starts from the 4^th digit. The number of digits to be extracted is the ordinal number of the second dot, 5^th digit, minus the ordinal number of the first dot plus one equals to 4. Then we extract from B2, starting from 4^th digit, just one digit.

We simply place the stroke between the months and the year.

The second function is RIGHT. Two arguments are needed: where to extracts and how many digits from right is extracted.

The formula takes digits from the cell B2, the number of digits to be extracted is 5. The length of the cell, how many digits are there in the cell B2 is 9. The second dot plus one equals to 5. The number of digits to be extracted is nine minus five.

Third option is format cell category to custom, then change type to mm/yyyy. So, two digits for the month and four digits for year.

In my Excel k represents month and v year.

The month is presented with two digits, February is zero two.