getting day number out of date text

[billyheanue]

COLUMN A:

[TABLE="width: 91"]
<colgroup><col></colgroup><tbody>[TR]
[TD]Row1: 1/30/2015[/TD]
[/TR]
[TR]
[TD]Row2: 12/7/2015[/TD]
[/TR]
</tbody>[/TABLE]
Row3: 3/15/2016

Looking to have formula return:

COLUMN B:

Row1: 30
Row2: 7
Row3: 15

Thank you!!!

 

[gallen]

=Day(A1) will return 30... and so on

 

[wideboydixon]

Or if the dates are stored as text then:

=DAY(DATEVALUE(A1))

WBD

 

[billyheanue]

and here i was doing =find("/")....=len ....=LEFT(

 

[gallen]

and here i was doing =find("/")....=len ....=LEFT(

We've all been there. I still find functions that I wonder how I never knew about them.