Thread: MONTH
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Connie Martin Connie Martin is offline
external usenet poster
 
Posts: 251
Default MONTH

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