Extract Date

[How_Do_I]

Hello I have data in Column A and would like to extract that data in date format in to Columns B and C... How would I go about that please...?

Excel Workbook
	A	B	C
2	1 (39)-50 (39), 1939 3 Sep-25 Sep (PDF, 106.611 MB)	03-Sep-1939	25-Sep-1939
3	51 (39)-100 (39), 1939 21 Sep-27 Oct (PDF, 97.278 MB)	21-Sep-1939	27-Oct-1939
4	101 (39)-150 (39), 1939 28 Oct-6 Dec (PDF, 78.001 MB)	28-Oct-1939	06-Dec-1939
Sheet1

 

[Rick Rothstein]

What would the cell value look like if the second date crossed Dec 31st into the next year?

Yes, the returns are a #VALUE error however, this is a one off thing so, once I have the dates I can remove the formulas... The formula that AhoyNC gave breaks the back of the work...!

I think you missed the point of my question... I was looking for you to tell me what the data line would look like if the second date crossed into the next year. For example, to go from November 25, 2017 to February 3, 2018... how would your data line show that? We need to know if the year is automatically affixed to the second date because it is different from the year for the first date or if we are supposed to assume the bridge between dates is always less than one year and calculate the year based on the month names provided.