How can I get data in middle of a field

Hello, I have an excel field that has this in Cell A1. report.6/5/2009.csv

I would like to write a formula so I only pick up the 5. There is a column full of dates for the month. I want to create a field that is just for "Day" only. So I would need the data between / /. I can't use characters because some days my have 2 characters for their day. Let me know if you know how I could get this data. Thanks in advance.

Try:

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