Extraction of date from Contents of text

Question

I have data in a certain cell in number format i.e. [0025092-08-24]. I just want to extract date [August 2024] in other cell. What formula will work?

Answer 1

To extract the date in the format "August 2024" from a cell containing data like "0025092-08-24", you can use the following formula in Excel:

Assuming the original data is in cell A1:

Extract the Year and Month:

excelCopy code
=TEXT(DATE(RIGHT(A1, 4), MID(A1, 6, 2), 1), "mmmm yyyy")

Explanation:

• RIGHT(A1, 4) extracts the year from the last 4 characters.
  • MID(A1, 6, 2) extracts the month from the characters starting at position 6 with length 2.
    • DATE function creates a date using the extracted year and month, with the day set to 1.
      • TEXT function formats the date as "mmmm yyyy", which gives the full month name and year.

This formula will convert "0025092-08-24" into "August 2024".
I hope it will work...

Answer 2

#VALUE! Problem