=Month(A1)

If this post helps click Yes
---------------
Jacob Skaria


"Jim" wrote:

Hello,

What formula can I use to pull out the month only on a date formatted as
follows:

3/28/2009

I know I can re-format the cell but I am interested in help with a formula

Thanks
Jim