I have tried using the text formula to extract the Month only from text from Nov-16, but it returns Mar
It would be appreciated if someone could asist me
Cell Formulas | ||
---|---|---|
Range | Formula | |
Q3 | =TEXT(LEFT(D2,3),"MMM") | |
R3 | =TEXT(LEFT(E2,3),"MMM") | |
S3 | =TEXT(LEFT(F2,3),"MMM") |
Excel 2012 | |||||
---|---|---|---|---|---|
D | E | F | |||
2 | Nov-16 | Dec-16 | Jan-17 | ||
Monthly Data |
It would be appreciated if someone could asist me