Pulling the first two letter out of the month field

[alexduy]

I would like to pull the month from 11/22/1982. In this case the function should return 11. Is there a formula to do that?

Thanks

[63falcondude]

Try the MONTH function.

Like this:

=MONTH("11/22/1982")

or this:

=MONTH(DATE(1982,11,22))

or this:

=MONTH(A1)
where the date is in cell A1.

[izzy-analytics]

If you want the actual letters... you can get it by LEFT ( TEXT( your date , "mmm") , 2)

[alexduy]

wow nice the MONTH function is exactly what i need. Thanks!

[63falcondude]

You're welcome. Happy to help.