MONTH should actually return a number between 1 and 12, but remember
that some formats use the month first and others place day first.
There is a YEAR function as well.

On May 2, 9:39 am, Connie Martin
wrote:
I used the formula =MONTH(H2) but it's giving me 'Jan' whereas it should be
giving me 'Mar'. The column with the dates is formated as date. What should
my formula be? I also need one for YEAR. Thank you. Connie