Extract date from inside other text in Excel

00:00 Extract date from string (month number in this case)
00:10 Find what shows Excel where the date starts in the text
00:20 Extract the character number of where the date starts
00:46 Pull out the month part of the date in the text
00:28 Convert number that shows a starting zero to just the number
01:40 Compare the extracted month number to the expected month number

Using Excel formula, extract the month part of date out of other text that contains the date within it e.g. Income Statement for 31/12/2023 of ACME limited.

[ishanrao]

Thanks it was really helpful I had to tweak the formula a little but it worked!😊