Thread: =YEAR(3/7/2007) in EXCEL, get the answer as 1900. Why?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
LadyCat LadyCat is offline
external usenet poster
  
Posts: 1
Default =YEAR(3/7/2007) in EXCEL, get the answer as 1900. Why?
I am expecting the answer as 2007 from the function of =YEAR(3/7/2007)
Reply With QuoteReply With Quote