How do I extract the month and year from TEXT in Excel?
How do I extract the month and year from TEXT in Excel? 1. Except the above formula, you can also apply this formula: =TEXT(A2, “mmm”) & “-” & TEXT(A2, “yyyy”). 2. In above formulas, A2 indicates the date cell that you want to use, and the separator “-” is used Read more…