Right , Left & Mid Functions are used to extract Text in Excel , but the Date Infos are aligned in Excel to the Right , which means that they are recognized in excel as numbers , am i wrong ? although it worked out , but i'm little confused . Can u clarify it please ? Thanks in advance !

Hi Moataz, Yes, we use RIGHT, LEFT, and MID to extract the date information from Excel. In this case, we are able to do that and obtain the desired output. An alternative would be to stick to a date formatting, but this is trickier when we work with pivot tables and GETPIVOTDATA (very often GETPIVOTDATA doesn't recognize the date formatting when we want to substitute in the formulat). In that case, probably many people would have ended up with mistakes while solving the exercise. This is why we solved the exercise in the way you have seen. Best, Ned

Follow this topic

Moataz Ahmed

Last answered:

08 Mar 2023

Posted on:

05 Mar 2023

Right & Left Functions

in Data Analysis with Excel Pivot Tables / Preliminary mapping of the data extraction

1 answers ( 0 marked as helpful)

Ned Krastev

Instructor

Posted on:

08 Mar 2023

Right & Left Functions

Submit an answer