Thread: No date entered still pulls a reult '1' through??
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jim Jim is offline
external usenet poster
  
Posts: 615
Default No date entered still pulls a reult '1' through??
In Excel 2007 i am using the formula =MONTH(P145) all the way down the
column, which if there is not date entry in columns that are not yet in use
the formula still pulls through a '1' which is mucking up all the
corrisponding information that is pulled for the month of Jan. Can anyone
advise me as to what i can do to get no result pulling through if there is
not a date entered into column P?
Thanks.
--
Jim
Reply With QuoteReply With Quote