Extract middle numbers

[L.LEE]

Hi

I have a string of numbers that look like this.
Apr 1 2019
Apr 2 2019
Apr 3 2019
Apr 4 2019
Apr 7 2019
Apr 8 2019
Apr 9 2019
Apr 10 2019
Apr 11 2019
Apr 14 2019
Apr 15 2019
Apr 16 2019
Apr 17 2019
Apr 18 2019
Apr 21 2019
Apr 22 2019
Apr 23 2019
Apr 24 2019
Apr 25 2019
Apr 28 2019
Apr 29 2019
Apr 30 2019

May I know the formula to extract the middle digits i.e. the day of the month?

thanks

[NeedForExcel]

If it is a Text String, this should work

=MID(A1,FIND(" ",A1)+1,FIND(" ",A1,FIND(" ",A1)+1)-FIND(" ",A1)-1)

If it is a date formated that way, then the below should work

=DAY(A1)

[L.LEE]

Thanks. When it comes to Apr 1 2019, the result is blank and not "1".

[FDibbins]

Or just this...
=--MID(A1,5,2)

[NeedForExcel]

Thanks. When it comes to Apr 1 2019, the result is blank and not "1".

Well it works for me.

[NeedForExcel]

Or just this...
=--MID(A1,5,2)

Why did I not think of that Haha!

[FDibbins]

Why did I not think of that Haha!

thats why I get paid the big bucks (NOT!!!)
lol

(thanks for the feedback )

[FDibbins]

L.LEE, happy to help and thanks for the feedback