As I said dates in Excel are serial numbers where one day equals 1 and they
start on Jan 0 1900 which means your MONTH formula returns 3 thus Excel see
it as the 3rd of January 1900 so it makes sense it will return Jan

--


Regards,


Peo Sjoblom



"Connie Martin" wrote in message
...
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