“The headers are “Sum of 1/31/2024” “Sum of 2/29/2024” etc. Is there a formula I can put in another row that just pulls the date from those cells?”

If you put that into an AI program (ChatGPT/Gemini/CoPilot/whatever) can you get a correct answer? Which are closest? Close enough to lead you to the right answer or are they way off?

Can the question be asked a bit differently to get a better answer?

I asked ChatGPT this question, just restating the problem a little more explicitly:

“I have an Excel spreadsheet which has cells containing strings of the form “Sum of mm/dd/yyyy” where “mm/dd/yyyy” is a date. The “mm” part and/or the “dd” part may be one or two digits. What formula can I use to extract the date into another cell?”

It gave this answer, which similar to but more complicated than Pasta’s answer in the original thread. The use of TEXT() to format the result goes a little beyond what was asked.

You can use a combination of Excel functions to extract the date from a string like “Sum of mm/dd/yyyy”. Assuming the string is in cell A1, you can use the following formula:

Your re-phrasing seems to have made it a text field instead of a date field. Is that better?

Here is what Copilot (Microsoft AI) gave to the question in the OP:

Yes, you can use a combination of Excel functions to extract the date from those header cells. Assuming your headers are in row 1, you can use the following formula to pull the date: