Member Avatar for Divinedar

I am trying to reference a cell with a date from one worksheet to the other. I am using ='Statistics MVP'!A16 but it doesn't give me the date format it just gives me the number 41125 or any other number. When I format as a date form I get 1/0/1900 and this is what I want to hide until a date is put in any cell that is being referenced. What I want is that if there is no date in cell A16 that I am referencing, I don't want it to show anything until a date is put in cell A16 but still show in date format. Any ideas anyone? Hope you understand.

I know how to hide zeros using 0;-0;;@ but it doesn't seem to be a way to use it in leu of the date format.

  • 2 Contributors
  • 2 Replies
  • 106 Views
  • 15 Hours Discussion Span
  • Latest Post Latest Post by Divinedar
Member Avatar for tinstaafl

try this function =IF(Sheet2!A1 = 0," ",Sheet2!A1) basically if the source = 0 then use a " " as the value otherwise use the value from the source.

Member Avatar for Divinedar

Perfect thank you.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.