Thank you everyone. The simple =H2 works. I don't know why =MONTH(H2) was
giving me 'Jan' because the date in the column was 30-Mar-99, and it was
formatted as a date, therefore it should've given me Mar or 3, whichever, but
I was getting Jan or 1. Made no sense. Even when I do =H2 I only get Mar,
so I don't have to format the column. This spreadsheet was downloaded from
SAP, but like I said I formatted the column to date format. Anyway, as long
as I've got the result I want, that's great! Thank you!

"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