Thread: datevalue returns #value
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
TomPl TomPl is offline
external usenet poster
  
Posts: 342
Default datevalue returns #value
Your date format is Day, Month, Year; not Month, Day, Year. Input your date
as 07/01/2009 and it should work.

rin
Reply With QuoteReply With Quote