Thread: When 1 sheet = a blank date field on another tab the result = 0-Ja
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Karen Ramel Karen Ramel is offline
external usenet poster
  
Posts: 1
Default When 1 sheet = a blank date field on another tab the result = 0-Ja
Using Excel 2003

How do I please get the result of the 'formula' to show BLANK when no date
is entered in the source field?

When a date IS entered in the source the display/value shown is fine.

Please advise
Reply With QuoteReply With Quote