View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Barry
 
Posts: n/a
Default month worksheet function returns wrong value

using formula =month(a1) and in a1 is a date of 01 01 2006 and it returns
value of 1 which is correct, however if i delete the date in a1 it still
returns a value of 1. how can I resolve this?