Thread: =YEAR(3/7/2007) in EXCEL, get the answer as 1900. Why?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Duke Carey Duke Carey is offline
external usenet poster
  
Posts: 1,081
Default =YEAR(3/7/2007) in EXCEL, get the answer as 1900. Why?
TRY

=YEAR("3/7/2007")

You are getting the year of the date represented by: 3 divided by 7 divided
by 2007, or a very small decimal amount.


"LadyCat" wrote:

I am expecting the answer as 2007 from the function of =YEAR(3/7/2007)
Reply With QuoteReply With Quote