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

Ladycat,

Put the date in quotes?

Beege
Reply With QuoteReply With Quote